Excel Tutorial: COUNTIF Function

The COUNTIF function counts the number of cells in a range that meet a given criteria. This function is useful when determining the repeat occurrence of data or data within a specified range. The COUNTIF function is defined as:

    = COUNTIF( range, criteria)

The inputs are defined as:

    range – the range of cells to be counted based on the criteria,

    criteria – the criteria used to determine which cells to count.

 

In this tutorial the COUNTIF function is used to count the number of times the selected range exceeds the Monthly Sales Goal.

The COUNTIF functions is defined by the following inputs.

    range – The range is the total sales value for the 6 months displayed in Table 1.

criteria – The criteria is all cells greater than the Monthly Sales Goal (Cell C8). The syntax for this criteria is “>”&C8.

The COUNTIF function counts the number of monthly Total Sales that are greater then the value of $11,000 and determines 6 times.


Download example here.

 

Do not forget to checkout our Excel Training and QuickBooks Courses if you are in South Florida!


Hector Garcia CPA and QuickBooks/Excel Trainer

Hector Garcia CPA and QuickBooks/Excel Trainer

Use our link to get 30% off for a year, valid through 07/31/2022

Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022