Sum values greater than a number
=SUMIF(B2:B9,">"&E1)Excel · result on the sample sheet: $8,480
Describe what you need and get a working SUMIF formula for Excel and Google Sheets, tested on real data before you copy it. SUMIF adds up values for the rows that meet one condition: total travel expenses, revenue for one product, every invoice over $500.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=SUMIF(B2:B9,">"&E1)Excel · result on the sample sheet: $8,480
=SUMIF(B2:B11,G1,D2:D11)Excel · result on the sample sheet: $5,155
=SUMIF(C2:C9,TRUE,B2:B9)Google Sheets · result on the sample sheet: $804.75
=SUMIF(B2:B8,"<"&F1,C2:C8)Excel · result on the sample sheet: $5,190
=C2/SUMIF($A$2:$A$10,A2,$C$2:$C$10)Excel · result on the sample sheet: 9 rows (D2:D10)
=SUM(B2:E2)Excel · result on the sample sheet: 4 rows (F2:F5)
=SUMIF($A$2:$A$11,E2,$B$2:$B$11)/SUM($B$2:$B$11)Excel · result on the sample sheet: 3 rows (F2:F4)
=IF(SUMIF($A$2:$A$8,D2,$B$2:$B$8)>E2,"Over limit","OK")Excel · result on the sample sheet: 3 rows (F2:F4)
You describe the task in plain English, and it writes the formula, using SUMIF where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
SUMIF adds up values for the rows that meet one condition: total travel expenses, revenue for one product, every invoice over $500.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the SUMIF function page has a practice exercise.