Using the COUNTIF statistical function  in Microsoft Excel 2019

The COUNTIF function counts the number of cells within arange that meet a condition you specify. Openthe CountFunctions.xlsx workbook to follow thisnext example given here:

  1. We will use the COUNTIF function to find out how manytimes View Tabue appears inthe Division column.
  2. The syntax of the formula is asfollows: =COUNTIF(range,criteria)
  3. Click into cell B13.
  4. Type =COUNTIF(F3:F30,"ViewTabue") 
  5. Press Enter to see the formula result.
  6. Click into cell B15, then use the COUNTIF function tocount all the surnames that start with the letter A.It is possible to use the wildcard characters such as * and ? for thispurpose—type =COUNTIF(D3:D30,”A*”).
  1. Press Enter to see the formula result.
  2. Use the COUNTIF function to count all the hourly ratesgreater than 15. Note that when using text (or characters on thekeyboard such as ?, *, <, > and <>), invertedcommas must be used around the criteria.
  3. Click into cell B17.
  4. Type =COUNTIF(J3:J30,”>15″).
  5. Press Enter to see the formula result.

For the next example, make sure you are on the second sheetin the workbook named COUNTIF2 (if youhave been following in the workbook calledCountFunctions.xlsx). We will then proceed asfollows:

  1. We will count how many students will achieve an award. Click intocell P3.
  2. Enter the following formula: =COUNTIF(M3:M17,”Y”).
  3. Press Enter to see the formula result.

For the next example, make sure you are on the third sheet ofthe CountFunctions.xlsx workbook. You can usethe COUNTIF function to count more than one criterion withina single range. Proceed as follows:

  1. Click into cell B19. To count how many times the Soningdaleand Munerton entries appear in the Divisions range, use the following formula:=COUNTIF(F3:F30,”Soningdale”)+COUNTIF(F3:F30,”Munerton”).
  2. Press Enter to see the formula result.

Leave a Comment