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.

 

img1

 

Follow the below given steps:-

  • 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.

 

img2

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube