Excel SUMIFS Donation Tracker
Budget: $10 – $30 USD
I have an Excel spreadsheet that lists individual monetary donations, and I need a straightforward way to track and summarize these contributions by month. A clean SUMIFS (or equivalent) solution that rolls totals into a simple monthly summary table is all I’m after—no macros or add-ins required.
What I’ll provide:
• The raw Excel file with donation dates and amounts.
What I need back:
• Correct SUMIFS (or similar) formulas inserted in the sheet to produce month-by-month totals.
• A brief note inside the workbook explaining how the formula works so I can maintain it later.
This is a quick, focused task; accuracy and clarity are more important than fancy formatting.
Dates across the top when a person contributes (Columns)
Person name along the left side (Rows)
Summarize contributions by months (mm yyyy)
What I’ll provide:
• The raw Excel file with donation dates and amounts.
What I need back:
• Correct SUMIFS (or similar) formulas inserted in the sheet to produce month-by-month totals.
• A brief note inside the workbook explaining how the formula works so I can maintain it later.
This is a quick, focused task; accuracy and clarity are more important than fancy formatting.
Dates across the top when a person contributes (Columns)
Person name along the left side (Rows)
Summarize contributions by months (mm yyyy)