Services offered worldwide
or
Your partner in computer software training & application development
for over 25 years
Microsoft Excel
COUNTIFS Function
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.
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.