FinanceTier 120 minintermediate

Accounts Receivable Aging

Use SUMIFS to bucket outstanding invoices into aging bands (current, 30, 60, 90+ days).

What you will learn

• Write a SUMIFS formula with two conditions (a lower and upper bound on days overdue)
• Explain why aging buckets need both a lower and upper bound, not just one comparison
• Recognise an invoice that has not yet gone overdue as distinct from a 0-day bucket

Excel skills

SUMIFS · Conditional Aggregation

The task

Bucket the outstanding invoices by how overdue they are. In B4, total the invoices that are between 31 and 60 days overdue - both bounds matter.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free