Scribd
Upload
6 views1 page

Mastering COUNTIF in Excel: A Guide

The COUNTIF function in Excel counts the number of cells that meet a specified condition within a range. It can be used for various queries, such as counting scores above a certain threshold or occurrences of specific text. Common mistakes include forgetting quotation marks for text, using incorrect ranges, and overlooking extra spaces.

Uploaded by

sidpan101
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views1 page

Mastering COUNTIF in Excel: A Guide

The COUNTIF function in Excel counts the number of cells that meet a specified condition within a range. It can be used for various queries, such as counting scores above a certain threshold or occurrences of specific text. Common mistakes include forgetting quotation marks for text, using incorrect ranges, and overlooking extra spaces.

Uploaded by

sidpan101
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Using the COUNTIF Function in Excel Help Sheet

The COUNTIF function counts how many cells meet a certain condition in a range. It’s perfect
for answering questions like:
> “How many students scored above 80?”
> “How many times does ‘Yes’ appear?”
> “How many products are out of stock?”

The Formula
=COUNTIF(range, criteria)

Range: The group of cells to look in


Criteria: What you’re checking for

Example 1: Counting Text


Goal: Count how many days where someone was supported (with “Yes” in column B)
=COUNTIF(B17:B22, “Yes”)

Example 2: Counting Numbers


Goal: Count scores greater than 80 in column B

=COUNTIF(B10:B12, “>100”)

Example 3: COUNTIF with Cell Reference


You can also use a cell reference instead of typing the criteria directly:
=COUNTIF(B17:B22, B24). This is using the value in B24; “No” in this example.

Tips & Common Mistakes

Mistake Fix It Like This


Forgot quotation marks for text Use "Yes" not Yes
Wrong range Make sure your range covers all cells
Extra spaces Check for typos or trailing spaces

Bonus things you can do with COUNTIF:

Task Formula Example


Count values not equal (use the <> sign) =COUNTIF(A1:A10,"<>Apples")
Count blank cells =COUNTIF(A1:A10,"")
Count specific number =COUNTIF(A1:A10,5)

Using COUNTIF is like giving Excel a mini search mission — and you’re in charge. With just one line, you
can spot patterns, answer questions, and impress with data!

Page 1 of 1

You might also like