- Главная
- Разное
- Дизайн
- Бизнес и предпринимательство
- Аналитика
- Образование
- Развлечения
- Красота и здоровье
- Финансы
- Государство
- Путешествия
- Спорт
- Недвижимость
- Армия
- Графика
- Культурология
- Еда и кулинария
- Лингвистика
- Английский язык
- Астрономия
- Алгебра
- Биология
- География
- Детские презентации
- Информатика
- История
- Литература
- Маркетинг
- Математика
- Медицина
- Менеджмент
- Музыка
- МХК
- Немецкий язык
- ОБЖ
- Обществознание
- Окружающий мир
- Педагогика
- Русский язык
- Технология
- Физика
- Философия
- Химия
- Шаблоны, картинки для презентаций
- Экология
- Экономика
- Юриспруденция
7 презентация
Содержание
- 1. 7
- 2. 1 Problem # How many cells contain numbers? Count Numbers
- 3. 1 Function # Only counts numbers Text
- 4. 2 Problem # How many cells contain any type of data? Count All Data
- 5. 2 Function # COUNTA Counts numbers, text,
- 6. 3 Problem # How many cells are empty? Count Empty Cells
- 7. 3 Function # COUNTBLANK Counts cells that
- 8. 4 Problem # How many orders for “Pen”? Count Specific Items
- 9. 4 Function # COUNTIF Counts cells that
- 10. 5 Problem # How many item names contain “Pen”? Count Partial Items
- 11. 5 Function # COUNTIF & * Wildcard
- 12. 6 Problem # How many Pen orders for 10 or more? Multiple Criteria
- 13. 6 Function # COUNTIFS Count based on
- 14. 7 Problem # How many numbers in filtered list? Filtered List
- 15. 7 Function # SUBTOTAL SUBTOTAL(102, Only counts
- 16. More Excel Functions Count Functions (get
- 17. Excel Tips & Tutorials http://www.contextures.com/ 30excelfunctionsin30days01.html Visit Contextures.com 30 Excel Functions Kit
1 Problem # How many cells contain numbers? Count Numbers
Слайд 31
Function #
Only counts numbers
Text and blank cells are ignored
NOTE: Dates are
numbers, so they would be counted too
COUNT
Слайд 52
Function #
COUNTA
Counts numbers, text, TRUE/FALSE
Blank cells are ignored
NOTE: Cells that look
blank might be counted, if they contain an empty string – ""
Слайд 73
Function #
COUNTBLANK
Counts cells that are empty
Cells with data are ignored
NOTE: Cells
that look blank might not be counted, if they contain an empty string – ""
Слайд 94
Function #
COUNTIF
Counts cells that contain exact data
NOTE: Criteria can be typed
in the formula, or use reference to another cell
Слайд 115
Function #
COUNTIF & *
Wildcard “*” used with criteria
“*” represents any characters
NOTE:
Criteria can be typed in the formula, or use reference to another cell
Слайд 136
Function #
COUNTIFS
Count based on multiple criteria
NOTE: Criteria can be typed in
the formula, or use reference to another cell
Слайд 157
Function #
SUBTOTAL
SUBTOTAL(102, Only counts numbers in visible rows
NOTE: Option 2 ignores
rows hidden by filter;
Option 102 also ignores manually hidden rows
Слайд 16More Excel Functions
Count Functions
(get the sample file for this slide
show)
Sum Functions
VLOOKUP Function
INDEX / MATCH Functions
INDIRECT Function
Sum Functions
VLOOKUP Function
INDEX / MATCH Functions
INDIRECT Function
Слайд 17Excel Tips & Tutorials
http://www.contextures.com/
30excelfunctionsin30days01.html
Visit Contextures.com
30 Excel Functions Kit
