Guided project · 6 steps Cellwise Plus
Volunteer hours report in Excel
Total each volunteer's hours, value their time, pull program hours for a grant report and pick who to thank.
You will use: SUMIF, IF, SUM, SUMIFS, DATE, MAX, XLOOKUP
Starting data
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Volunteer | Program | Date | Hours | Volunteer | Hours | Recognition | Total hours | |||
| 2 | Rosa | Food pantry | Sep 26, 2026 | 4 | Rosa | Value per hour (your rate) | 30 | ||||
| 3 | Tom | Tutoring | Oct 6, 2026 | 2 | Tom | Value of time | |||||
| 4 | Kai | Food pantry | Oct 10, 2026 | 3.5 | Kai | Food pantry, October | |||||
| 5 | Rosa | Food pantry | Oct 17, 2026 | 4 | Lena | Top volunteer | |||||
| 6 | Lena | Tutoring | Oct 20, 2026 | 2 | Award at (hours) | 6 | |||||
| 7 | Tom | Tutoring | Oct 27, 2026 | 2 | |||||||
| 8 | Rosa | Park cleanup | Oct 31, 2026 | 3 | |||||||
| 9 | Lena | Food pantry | Oct 24, 2026 | 3 | |||||||
| 10 | Kai | Food pantry | Nov 1, 2026 | 3.5 | |||||||
| 11 | Rosa | Food pantry | Oct 3, 2026 | 5 |
Build it step by step
Step 1
Total each volunteer's hours from the log. Write it in G2 and fill to G5.
Step 2
Show "Thank-you award" in H2 when a volunteer has at least the hours in K6, otherwise leave it blank (""). Fill to H5.
Step 3
Add up all volunteer hours in K1.
Step 4
Value the volunteer time in K3: total hours times the hourly value in K2.
Step 5
Your food pantry grant asks for October hours only. Total Food pantry hours dated October 1 to October 31, 2026 in K4.
Step 6
Who gave the most hours? Put their name in K5.