# 7 Ways to Count in Excel

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.

Description

Text

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

Comments

##### View more

Login or Join

Processing

**Login successful.**

*The system will automatically switch to the previous page after 6 seconds*