# COUNTIF ## Definition(s) ### [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]] #### [[Spreadsheet]] >[! Definition] >A spreadsheet function that counts the number of cells that meet a criteria passed to the function as an argument. ## Examples ### Spreadsheet ```excel =COUNTIF(range start : range end, evaluation argument) =COUNTIF(A2:A9, "Taxi") =COUNTIF(B2:B9, ">=10") =COUNTIF(B2:B9, ">="&B22) ``` The first example shows a COUNTIF function that counts the number of times the string Taxi appears in the range The second example shows a COUNTIF function that counts the number of time the numerical value is greater than or equal to 10 in the data range The third example shows a COUNTIF function that counts the number of times the numerical value is greater than or equal to the value given in cell B22. >[! note] >`&` concatenates additional cell reference to the evaluation argument. ## Related [[Function#Spreadsheet functions|Spreadsheet Functions]] ## Resources ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/) The {{COUNTIF}} function takes a data range and an evaluation statement. The function returns the number of cells that meet the evaluation criteria.