Using COUNTIF in Google Sheets is pretty easy. Just follow these simple steps to use it in Google Sheets document
Open your Google Sheets document
Select the Cells where you want to Countif the results
Now, type the COUNTIF formula for your data =COUNTIF(A2:A10, “>50”)
Specify range and criterion For example :=COUNTIF(A2:A10, “>50”)
By putting all the values, click Enter button
For better understanding of counif you have to know about Sum formulas if you have no knowledge about formulas Click Here
·
Tags
Advance Featues