Cart Login
Quick, clean, and to the point
Training Videos Functions Formulas Shortcuts
Search...
Excel COUNTIF Function
open in browser PRO version Are you a developer? Try out the HTML to PDF API pdfcrowd.com
Formula examples
Count cells that contain five characters
Count cells greater than
Extract unique items from a list
Count cells not equal to
Count cells that contain text
If cell begins with x, y, or z
Highlight duplicate values
open in browser PRO version Are you a developer? Try out the HTML to PDF API pdfcrowd.com
Purpose
Count cells that match criteria
Return value
A number representing cells counted.
Popular Topics
Functions |
Syntax
Formulas
=COUNTIF (range, criteria) Pivot Tables
Conditional
formatting
Arguments VLOOKUP | IF
range - The range of cells to count. function
Keyboard
criteria - The criteria that controls which cells should be
shortcuts
counted.
Excel experts |
Books
Usage notes
open in browser PRO version Are you a developer? Try out the HTML to PDF API pdfcrowd.com
The COUNTIF function in Excel counts the number of
cells in a range that match the supplied criteria
Non-numeric criteria needs to be enclosed in double
quotes but numeric criteria does not:
= COUNTIF(A1:A10,100) // count cells
equal to 100
= COUNTIF(A1:A10,">32") // count
cells greater than 32
= COUNTIF(A1:A10,"jim") // count
cells equal to "jim"
= COUNTIF(A1:A10,"<" & B1) // count
cells less than value in B1
The wildcard characters ? and * can be used in criteria. A
question mark matches any one character and an asterisk
matches any sequence of characters.
To find a literal question mark or asterisk, use a tilde (~)
in front question mark or asterisk (i.e. ~?, ~*).
open in browser PRO version Are you a developer? Try out the HTML to PDF API pdfcrowd.com
See links on this page to more examples with detailed
explanations.
Video tips
How to compare two lists and highlight differences
How to use the COUNTIF function
Excel Formula
Training
Bite-sized videos in plain
English. Learn functions
like IF, VLOOKUP, INDEX
& MATCH, COUNTIFS,
RANK, SUMIFS, SMALL,
LARGE, and plus formulas
for dates and text. Master
absolute and relative addresses, named ranges,
open in browser PRO version Are you a developer? Try out the HTML to PDF API pdfcrowd.com
errors, and troubleshooting. Instant access & full
guarantee. Watch samples.
300 Formula Examples, thoughtfully explained.
I really appreciate your delivery of the videos, the clean
and sharp documentation and pleasant to the eye website,
uncluttered, direct, short and snappy. From what I've
checked out elsewhere nothing compares... - Christina
Excel video training
Quick, clean, and to the
open in browser PRO version Are you a developer? Try out the HTML to PDF API pdfcrowd.com
point.
Learn more
© 2012-2016 Exceljet.
Home About Blog Contact Help us Search
TwitterFacebook
Google+
RSS
open in browser PRO version Are you a developer? Try out the HTML to PDF API pdfcrowd.com
