Calculate Tile Area by Type
I need to sum the 'Square Footage' where Tile Type is 'Ceramic' and Room is 'Bathroom'.
=SUMIFS(D2:D8, B2:B8, "Ceramic", C2:C8, "Bathroom") How it works: The SUMIFS function allows you to sum values in a range that meet multiple criteria. In this scenario, `D2:D8` is the range containing the 'Square Footage' to be summed. `B2:B8` is the first criteria range, where the function looks for 'Ceramic' tile types. `C2:C8` is the second criteria range, where it looks for 'Bathroom' rooms. Only rows that satisfy *both* conditions will have their 'Square Footage' added to the total, providing a precise calculation for the Flooring Specialist.
Data Setup
| Project ID | Tile Type | Room | Square Footage |
|---|---|---|---|
| P101 | Ceramic | Bathroom | 50 |
| P102 | Porcelain | Kitchen | 120 |
| P103 | Ceramic | Bathroom | 75 |
| P104 | Vinyl | Bedroom | 80 |
| P105 | Ceramic | Kitchen | 60 |
| P106 | Porcelain | Bathroom | 40 |
| P107 | Ceramic | Bathroom | 100 |
Step-by-Step Guide
Open your Excel worksheet containing the flooring project data.
Identify the column that contains the 'Square Footage' you want to sum (e.g., Column D). This will be your sum_range.
Identify the column that contains the 'Tile Type' (e.g., Column B). This will be your first criteria_range.
Identify the column that contains the 'Room' (e.g., Column C). This will be your second criteria_range.
In an empty cell, type the SUMIFS formula: `=SUMIFS(D2:D8, B2:B8, "Ceramic", C2:C8, "Bathroom")`.
Press Enter to get the total square footage for ceramic tiles specifically in bathrooms.