Embedded Files
The Countif function allows you to count the number of times the criterion appears in the range. With the Countifs function, you are able to repeat the range and criterion arguments.
Watch the video to learn more about the Countif and Countifs functions!
Follow along! Create a Google Sheets copy of the workbook shown in the video by clicking the button below.
Below you will find the Countif and Countifs functions, along with the formulas we use in the video.
The Countif and Countifs functions
The Countif and Countifs functions
COUNTIF(range, criterion)
COUNTIFS(criteria_range1, criterion1, [criteria_range2, …], [criterion2, …])
range = Where the data we want counted is.
criterion = What to look for in the range.
Final formulas from the video
Final formulas from the video
Countif/Countifs with text and numbers:
Grass Surfaces: =COUNTIF(E5:E34,"grass")
Grass Surfaces and Opened in 2000: =COUNTIFS(E5:E34,"grass",F5:F34,2000)
Grass Surfaces and Opened between 2000 and 2009 (inclusive): =COUNTIFS(E5:E34,"grass",F5:F34,">=2000",F5:F34,"<=2009")
Countif/Countifs with cell references:
Grass Surfaces: =COUNTIF(E5:E34,H5)
Grass Surfaces and Opened in 2000: =COUNTIFS(E5:E34,H5,F5:F34,I5)
Grass Surfaces and Opened between 2000 and 2009 (inclusive): =COUNTIFS(E5:E34,H5,F5:F34,">="&I5,F5:F34,"<="&J5)
Page updated
Google Sites
Report abuse