Round an account total
What is the total of all Supplies postings, rounded to two decimals?
Formula: =ROUND(SUMIFS(C2:C8,B2:B8,"Supplies"),2) → 285
Hands-on Excel exercises
Excel Skills for Accountants
Practice Excel for accounting work: a small ledger, SUMIFS by account and month, rounding, and control-total checks with worked answers.
Accountants live in ledgers: a date, an account, an amount, repeated for thousands of rows. The spreadsheet question is nearly always the same, namely what is the total for this account in this period, and does the whole thing tie out? Employers screening accounting candidates usually check that you can answer that with SUMIFS on text and dates, round currency sensibly, and leave a control that a reviewer can verify.
The live sheet is a month-end ledger with seven postings across Rent, Supplies, and Utilities, including entries from February and April that must not be counted. Your task is the March rent total, which needs one account criterion and two date criteria built with DATE. The worked answers add a rounded account total, a total of all postings as a simple control, and a count of postings to a single account.
Practice with the discipline of a close. Do not change source rows, state your period boundaries, and compare your formula to a filter on the same conditions. Floating-point sums can leave tiny fractions, so wrap currency totals in ROUND. For reconciliations and lists with unmatched items, the advanced skills page has a method for counting what is missing. This page uses fictional amounts only.
Your turn
Your turn: in F2, total the Rent postings dated in March 2024 (on or after 1 March and before 1 April).
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Date | Account | Amount | |||
| 2 | 2/28/2024 | Rent | 2400 | |||
| 3 | 3/1/2024 | Rent | 2400 | |||
| 4 | 3/9/2024 | Supplies | 185.4 | |||
| 5 | 3/15/2024 | Utilities | 312.75 | |||
| 6 | 3/31/2024 | Rent | 150 | |||
| 7 | 4/1/2024 | Rent | 2400 | |||
| 8 | 3/20/2024 | Supplies | 99.6 | |||
| 9 |
Not yet solved.
Answer: =SUMIFS(C2:C8,B2:B8,"Rent",A2:A8,">="&DATE(2024,3,1),A2:A8,"<"&DATE(2024,4,1))
Practice under a time limit
Try the free Sample mock exam with 4 tasks in 8 minutes, or browse the level and interview mock exams included with Pro + Exams.
Related exercises
Open a task in its lesson.
- In C7, calculate how many items were bought in total.
- In F2, calculate the total of Emma's deals in Boston.
- In G2:G4, look up the item price.
- In G2:G6, turn the text in column A into numbers (some have spaces at the edges).
- Build a second PivotTable: the average deal amount by city, with the result in F8.
- In F2:F6, calculate the gross pay including the bonus, rounded to the dollar.
- Fix D3: the average price of coffee.
Worked answers
Try the spreadsheet first, then compare your formula and result.
Control total of all postings
What is the sum of every posting in C2:C8, rounded to two decimals?
Formula: =ROUND(SUM(C2:C8),2) → 7947.75
Count postings to one account
How many postings are to the Rent account?
Formula: =COUNTIFS(B2:B8,"Rent") → 4
Frequently asked questions
Why build date criteria with DATE?
Joining a comparison operator and a DATE result makes the boundary explicit and independent of regional date formats.
Why round currency totals?
Binary arithmetic can leave fractions such as 0.0000001. Rounding to cents keeps totals comparable and printable.
What control should I leave for a reviewer?
A total of all postings and a count of rows, so the reviewer can see that nothing was dropped when you filtered by account.
Is this real accounting data?
No. All amounts are fictional. Never practice with real ledgers or client data.