You're a finance analyst closing the month and tying out spend by GL account. Columns A–D hold 14 transactions: Date (A), Vendor (B), GL Account (C), Amount (D). Three GL accounts you need totals for are pre-populated in column F.
Your task:
- In column G (Total), write a SUMIF that returns total spend for each GL account in column F.
- The formula must drag-fill from G2 → G4.
Graded cells: G2, G3, G4.
Open this problem on a desktop to attempt it.