Use of CountIfs Function in Microsoft Excel 2010

If we need to count based on multiple criteria we should use the “COUNTIFS” function in Microsoft Excel 2010.

COUNTIFS: “COUNTIFS” function is used to count the entries in multiple range based on multiple criteria.

Syntax of “COUNTIFS” function:
=COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…)

Let’s take an example to understand how we can use this function.

Example 1: We have data in the range A1:C28,in which column A contains Dates, column B “Name”, column C “Revenue”. In column D we need to return the number of times revenue was collected by a person in a day.

• Select the Cell D2, and write the formula
• =COUNTIFS (\$A\$2:\$A\$28, A2, \$B\$2:\$B\$28, B2).
• Press Enter on the keyboard.
• The function will return the number. of times , that “Aaron” picked the revenue on 10th of February.
• To return the value for all candidates Copy the formula in all cells by pressing the key “CTRL + C” and select the cell D3 to D28 and press key “CTRL + V” on the keyboard.

This function uses columns A & B as the criteria column. The result has to be obtained based on a match obtained in both columns.

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.