# COUNTIFS ## Definition(s) ### Context: [[Nexus - Google Analytics Certificate Course#5.4 Google Analytics - 5 Analyze - Module 4 - Perform data calculations Perform Data Calculations|Google Analytics Certificate]] #### Sub-context: [[Function#Spreadsheet functions]] >[! Definition] >is a function that counts the number of cells in a range that meet a single condition ## Examples ```excel =COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) =COUNTIFS(A2:A8, "ProductA", B2:B8, "East", C2:C8, "Q2") ``` ## Related [[SUMIFS|=SUMIFS()]] [[COUNTIF|=COUNTIF()]] ## 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/) is a function that counts the number of cells in a range that meet a single condition @@ [[COUNTIFS|=COUNTIFS()]]