How to SUM Values Between Conditions in Excel or Google Sheets

Master conditional summing with just one formula. No filters. No scripts.

If you’re tired of manually filtering data just to total some numbers, it’s time to learn SUMIF — one of the most useful conditional formulas in Excel or Google Sheets.

You want to total only the quantities where the price is greater than 0.75.

Formula Used:

=SUMIF(C2:C6, “>0.75”, B2:B6)

How It Works:

• C2:C6 → The range you're checking the condition against (Price)
• ">0.75" → The condition you’re applying
• B2:B6 → The range you want to sum (Quantity)

Result:

Only rows with price > 0.75 are summed:

• Apple: 10
• Orange: 8
• Mango: 12

Total: 30

This method is fast, dynamic, and requires no filtering or pivot tables. It’s great for dynamic reports, sales analysis, and real-time dashboards.

For more concise, time-saving spreadsheet tips, follow Byte Plane.

[embed]