# 7 Ways to Count in Excel

by debra-dalgleish

126,489

views

#### Comments

#### Description

**Download 7 Ways to Count in Excel**

#### Transcript

Excel Video Tutorials
Ways to
Count
in Excel
7
Function Tips and Tricks
1
1
Problem #
How many cells contain numbers?
Count Numbers
2
1
Function #
Only counts numbers
Text and blank cells are ignored
NOTE: Dates are numbers, so they would be counted too
COUNT
3
2
Problem #
How many cells contain any type of data?
Count All Data
4
2
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 â ""
5
3
Problem #
How many cells are empty?
Count Empty Cells
6
3
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 â ""
7
4
Problem #
How many orders for âPenâ?
Count Specific Items
8
4
Function #
COUNTIF
Counts cells that contain exact data
NOTE: Criteria can be typed in the formula, or use reference to another cell
9
5
Problem #
How many item names contain âPenâ?
Count Partial Items
10
5
Function #
COUNTIF & *
Wildcard â*â used with criteria
â*â represents any characters
NOTE: Criteria can be typed in the formula, or use reference to another cell
11
6
Problem #
How many Pen orders for 10 or more?
Multiple Criteria
12
6
Function #
COUNTIFS
Count based on multiple criteria
NOTE: Criteria can be typed in the formula, or use reference to another cell
13
7
Problem #
How many numbers in filtered list?
Filtered List
14
7
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
15
More Excel Functions
Count Functions
(get the sample file for this slide show)
Sum FunctionsÂ
VLOOKUP FunctionÂ
INDEX / MATCH Functions
INDIRECT FunctionÂ
16
Excel Tips & Tutorials
http://www.contextures.com/
30excelfunctionsin30days01.html
Visit Contextures.com
30 Excel Functions Kit