Use COUNTIF function for conditional statistics

Uploaded time: September 30, 2021 Difficulty: Primary

Use COUNTIF function for conditional statistics

Use COUNTIF function for conditional statistics

Tips: After starting to play, you can adjust the video clarity, click


Auto 720p

Graphic skills

COUNTIF is a statistical function. It is often used to count the number of cells that meet the criteria. This function can not only count numbers and text but also can count expressions. So how can we use this function?


The grammatical structure of the COUNTIF function is: COUNTIF(Range, Criteria)

Range is the cell range that meets the criteria.

Criteria are the conditions that need to be counted.

1 (1).gif

Now we have a table that records everyone's afternoon tea order information. Column B contains the persons' names who ordered, and column C records the ordered food of afternoon tea. We now need to calculate the amount of Cheesecake that we have ordered.

1 (2).gif

Click cell F7 and click Insert Function to find the COUNTIF function. Click the OK button, now a dialog box will pop up.

1 (3).gif

Since we want to count the amount of Cheesecake in this table of afternoon tea order information, enter C3:C29 in the Range.

1 (4).gif

Enter Cheesecake in Criteria, or click cell E7. After clicking the OK button, we can quickly count the specific amount of Cheesecake.

1 (5).gif

In the same way, we can also count the number of orders for Blueberry Cheese Bread and Fried Chicken.This is the basic use of the COUNTIF function. Did you get it

This skill could be also used in Microsoft Office Excel and Openoffice.