FinanceTier 912 minbeginner

Average Invoice Value, Excluding the Total Row

Average a list of invoices without accidentally averaging in the total row beneath them.

What you will learn

• Scope an AVERAGE range to stop exactly at the last real data row
• Explain why including a Total row in an average inflates the result
• Recognise when a range one row too long silently corrupts a summary figure

Excel skills

AVERAGE · Statistical Functions

The task

Eight invoices are listed, followed by a "Total" row. Work out the average invoice value in Summary!B3, without letting the total row itself get averaged in as if it were an invoice.

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