# SUMIFS ## 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] >Similar to [[SUMIF|=SUMIF()]], but can accept multiple conditional statements to evaluate. ## Examples ```excel =SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) =SUMIFS(D2:D8, A2:A8, "ProductA", B2:B8, "East", C2:C8, "Q1") ``` ## Related [[Function#Spreadsheet functions|Spreadsheet functions (list)]] [[SUMIF|=SUMIF()]] [[COUNTIFS|=COUNTIFS()]] ## 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/) Similar to [[SUMIF|=SUMIF()]], but can accept multiple conditional statements to evaluate. @@ [[SUMIFS|=SUMIFS()]]