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.
Follow the below given steps:-
This function uses columns A & B as the criteria column. The result has to be obtained based on a match obtained in both columns.
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.