top of page

Microsoft Excel
COUNTIFS Function

Excel Icon.png
Back Button

Use COUNTIFS to conditionally count a range of values or text, based on a multiple criteria

Would you like to know how many times you sold a particular product in a specified city that was at least $50,000? Or how many times a specified rep sold a particular product?   COUNTIFS will quickly and easily accomplish this!

In the example below, we count the number of copiers sold by city with a sale amount of greater than or equal to $10,000.

Step 1. Set up your data correctly, preferably converting it to a table.  In our example, we named our table tblSales.

Countifs.jpg

Step 2. Add the COUNTIFS formula to the # Sales column H, that refers to column G for the city, for the results in the table below.

DETAILED EXPLANATION

SYNTAX:  =COUNTIFS(Criteria range 1, Criteria1, Criteria range 2, Criteria 2, Criteria range 3, Criteria 3)

 

EXAMPLE: Formula example if referring to a table range (tables are preferable, as will expand/contract as add/remove data):

=COUNTIFS(tblSales[Product],"Copier",tblSales[City],G2,tblSales[Amount],">=10000")

 

Give the COUNTIFS function a try, and let us know if you have any questions, or would like to arrange training on this

or other Excel functions and features!

© 2022 DJH Training & Application Solutions Inc.

bottom of page