Sum Textbook Sales by Course
I need to sum 'Sales' where Course is 'BIO101' and Condition is 'New'. This helps me track revenue for specific high-demand textbooks.
=SUMIFS(D2:D8, B2:B8, "BIO101", C2:C8, "New") How it works: The SUMIFS function is designed to sum values in a range that meet multiple criteria. In this formula, `D2:D8` is the range of sales figures to be summed. `B2:B8` is the first criteria range, and `"BIO101"` is the condition that must be met within that range. Similarly, `C2:C8` is the second criteria range, and `"New"` is its corresponding condition. The function will only add a sale to the total if both the course is 'BIO101' AND the condition is 'New'.
Data Setup
| Transaction ID | Course | Condition | Sales |
|---|---|---|---|
| 1001 | BIO101 | New | 50.00 |
| 1002 | CHM201 | Used | 30.00 |
| 1003 | BIO101 | New | 65.00 |
| 1004 | PHY101 | New | 75.00 |
| 1005 | BIO101 | Used | 40.00 |
| 1006 | BIO101 | New | 55.00 |
| 1007 | CHM201 | New | 45.00 |
Step-by-Step Guide
Open your sales data spreadsheet.
Identify the column containing the 'Sales' figures (e.g., Column D). This will be your 'sum_range'.
Identify the column containing the 'Course' names (e.g., Column B). This will be your first 'criteria_range'.
Specify your first 'criteria' as "BIO101" (enclosed in double quotes).
Identify the column containing the 'Condition' of the books (e.g., Column C). This will be your second 'criteria_range'.
Specify your second 'criteria' as "New" (enclosed in double quotes).
Enter the formula `=SUMIFS(D2:D8, B2:B8, "BIO101", C2:C8, "New")` into an empty cell and press Enter.