Sum Donations by Grade Level
As a Fundraising Chair, I need to sum 'Donation Amount' where the 'Grade' is '10th' and the 'Fund' is 'Sports'. This helps me track specific campaign performance.
=SUMIFS(E2:E8, C2:C8, "10th", D2:D8, "Sports") How it works: The SUMIFS function allows you to sum values in a range that meet multiple criteria. In this case, it looks at the 'Donation Amount' (E2:E8) and only adds a value to the total if the corresponding 'Grade' (C2:C8) is exactly '10th' AND the 'Fund' (D2:D8) is exactly 'Sports'. All conditions must be true for a donation to be included in the sum, providing a precise total for specific fundraising segments.
Data Setup
| Donation ID | Donor Name | Grade | Fund | Donation Amount |
|---|---|---|---|---|
| 1 | Alice | 10th | Sports | 100 |
| 2 | Bob | 9th | Arts | 50 |
| 3 | Charlie | 10th | Sports | 200 |
| 4 | David | 11th | Sports | 150 |
| 5 | Eve | 10th | Science | 75 |
| 6 | Frank | 10th | Sports | 300 |
| 7 | Grace | 9th | Sports | 120 |
Step-by-Step Guide
Identify the column containing the amounts you want to sum (Donation Amount, column E). This will be your 'sum_range'.
Identify the first criteria range (Grade, column C) and the corresponding criterion ("10th").
Identify the second criteria range (Fund, column D) and the corresponding criterion ("Sports").
Enter the SUMIFS formula into an empty cell: `=SUMIFS(E2:E8, C2:C8, "10th", D2:D8, "Sports")`
Press Enter to see the total sum of donations that meet both conditions.