How to Use Excel COUNTIFS Function (Examples + Video)

In this article, I will cover the syntax of COUNTIFS function and how to use in it Excel.

When to use Excel COUNTIFS Function

COUNTIFS function can be used when you want to count the number of cells that meet a single or multiple criteria.

Excel COUNTIFS Function

What it Returns

It returns a number that represents the number of cells that met a specified criteria in the specified range(s).

Syntax

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Input Arguments

  • criteria_range1 – The range of cells for which you want to evaluate against criteria1.
  • criteria1 – the criteria which you want to evaluate for criteria_range1 to determine which cells to count.
  • [criteria_range2] – The range of cells for which you want to evaluate against criteria2.
  • [criteria2] – the criteria which you want to evaluate for criteria_range2 to determine which cells to count.

Additional Notes

  • Criteria could be a number, expression, cell reference, text, or a formula.
  • Criteria which are text or mathematical/logical symbols (such as =,+,-,/,*) should be in double quotes.
  • Wildcard characters can be used in criteria.
    • There are three wildcard characters in Excel – the question mark (?), asterisk (*), and tilde (~)
      • A question mark matches any single character
      • An asterisk matches any sequence of characters.
      • If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
  • Criteria are case insensitive (“Hello” and “hello” are treated as same).
  • Cells in counted only when all the conditions are met.
  • Up to 127 pairs to criteria and criteria range are allowed.
  • If the criteria argument is a reference to an empty cell, the COUNTIFS function treats the empty cell as a 0 value

Excel COUNTIFS Function – Live Example

Excel COUNTIFS Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment