You're a revenue analyst handed a 25-row transactions table (columns A–C: TxID, Date, Amount) and a chart your manager already approved (shown in the panel). The chart plots total revenue per calendar month for 2025, January through December.
Your task:
- Reproduce the 12 monthly totals shown in the chart in cells F2 through F13 — F2 = January, F3 = February, …, F13 = December.
Hint: column B is text-shaped ISO dates (2025-01-08), not numeric serials, so SUMIFS with DATE(...)-bounded criteria silently returns 0. Use MONTH-based comparison instead — SUMPRODUCT((MONTH($B$2:$B$26)=ROW()-1)*$C$2:$C$26) drag-fills cleanly down F2:F13. Each transaction has a 2025 date, so comparing on month alone is sufficient.
Graded cells: F2 through F13.
Open this problem on a desktop to attempt it.