Ravindra BagaleCourses & study guides Track your progress

29. SQL for Excel Users (Term Map + Side-by-Side)

29.1 WHERE = Filter / SUMIFS Conditions

By Last updated:

Why. Excel filter and SUMIFS map cleanly to WHERE.

What. AutoFilter / SUMIFS conditions ≈ WHERE clause predicates.

How. Excel: sum sales where city=Pune → SQL: SUM… WHERE city='Pune'.

Steps

  1. Write the Excel condition in words.
  2. Translate to WHERE.
  3. Run SUM with WHERE on raja_coffee.

Examples

Example 1 · dataset: raja_coffee

SELECT ROUND(SUM(amount_inr),2) AS pune_sales_inr
FROM orders
WHERE city = 'Pune';

Output

pune_sales_inr
9170.0

Meaning. Same idea as SUMIFS on City = Pune.

Ravindra Bagale's Tip

Full map: /guides/excel-vs-sql.html