Edit any cell in the tables below — all formula results update live.
Edit any cell below to see how each formula changes.
| Item | Category | Price ($) | Quantity | Date |
|---|---|---|---|---|
| Apple | Fruit | 1.20 | 5 | 2025-01-10 |
| Banana | Fruit | 0.50 | 3 | 2025-01-11 |
| Carrot | Vegetable | 0.80 | 2 | 2025-01-12 |
| Broccoli | Vegetable | 1.50 | 4 | 2025-01-13 |
| Orange | Fruit | 1.00 | 1 | 2025-01-14 |
| Spinach | Vegetable | 2.00 | 6 | 2025-01-15 |
Sum of Price where Category = "Fruit"
Sum of Price where Category = "Fruit" AND Quantity > 2
Count of rows where Category = "Vegetable"
Count of rows where Category = "Fruit" AND Quantity > 1
Average Price where Quantity >= 3
Sum of Price * Quantity for all rows
💡 Try it: Change any value in the data table above — all formula results update instantly.
This playground demonstrates the logic behind Excel's conditional aggregate functions using a live, editable dataset.