Administration and Executive AssistantTier 825 minadvanced

BYROW: Per-Person Totals

Total each person's expenses individually, without mixing everyone's figures together.

What you will learn

• Use BYROW with LAMBDA to apply the same calculation to each row of a range separately
• Explain why summing a whole block at once mixes every row together
• Recognise the difference between one person's total and the grand total of everyone combined

Excel skills

BYROW, LAMBDA · Array Formulas

The task

Eight people's expenses are listed across four categories. Work out the first person's total expenses in Summary!B3, without mixing in anyone else's spending.

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