Sum formulas
Totals with conditions, running totals, totals across columns and ranges that grow. 6 answers, each checked by running it, with a live example and an exercise.
How to sum values based on criteria in Excel (SUMIF)
=SUMIF(B2:B11,G1,D2:D11)Use =SUMIF(criteria_range, criteria, sum_range): it adds the numbers in sum_range on the rows where criteria_range matches.
How to sum with multiple criteria in Excel (SUMIFS)
=SUMIFS(D2:D11,B2:B11,G1,C2:C11,G2)Use SUMIFS with the sum range first, then one range-and-condition pair per criterion: =SUMIFS(sum_range, range1, crit1, range2, crit2).
How to calculate a running total in Excel
=SUM($B$2:B2)Sum from a locked first cell to the current row, =SUM($B$2:B2), and fill it down. The range grows by one row each time.
How to sum values between two dates in Excel
=SUMIFS(D2:D11,A2:A11,">="&G1,A2:A11,"<="&G2)Use SUMIFS with two date conditions on the same column: =SUMIFS(sum_range, dates, ">="&start, dates, "<="&end).
How to sum if a cell contains specific text in Excel
=SUMIF(A2:A9,"*"&E1&"*",B2:B9)Use SUMIF with wildcards around the text: =SUMIF(range,"*"&text&"*",sum_range).
How to sum the top 3 values in Excel
=SUM(LARGE(B2:B8,{1,2,3}))Use LARGE with an array of ranks inside SUM: =SUM(LARGE(range,{1,2,3})).