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
Please download to view
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.
...

7 Ways to Count in Excel

by debra-dalgleish

on

Report

Download: 17

Comment: 0

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
Fly UP