FinanceTier 612 minintermediate

Average Transaction Size by Category

Average only the transactions in one category, not the whole column.

What you will learn

• Write an AVERAGEIF formula scoped to one category
• Explain why a plain AVERAGE over the whole column mixes every category together
• Recognise when a conditional average is the correct tool over a simple one

Excel skills

AVERAGEIF · Statistical Functions

The task

Find the average transaction size for Retail specifically, not the average across every category mixed together. In Summary!B2, write a formula that averages only the Retail transactions.

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