# SUMIF ## 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] >A spreadsheet function that will sum values of a specified column (the `range to be summed`) if the value of a cell within another specified column (the `range to be evaluated`) meets a given criteria (the `"evaluation terms"`). ## Examples ```excel =SUMIF(range to be evaluated, "evaluation terms", range to be summed) =SUMIF(C2:C900, "<=100", D2:D900) ``` ## Related [[COUNTIF|=COUNTIF()]] [[COUNTIFS|=COUNTIFS()]] [[SUMIFS|=SUMIFS()]] ## 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/) A spreadsheet function that will sum values of a specified column (the `range to be summed`) if the value of a cell within another specified column (the `range to be evaluated`) meets a given criteria (the `"evaluation terms"`). @@@ [[SUMIF|=SUMIF()]]