Administration and Executive AssistantTier 825 minadvanced

SCAN: Running Balance

Build a running balance that starts from the real opening balance, not zero.

What you will learn

• Use SCAN with LAMBDA to build a running total across a list
• Explain what SCAN's first argument controls
• Recognise that starting from zero instead of the real opening balance offsets every figure by the same amount

Excel skills

SCAN, LAMBDA · Array Formulas

The task

An account has an opening balance and a list of deposits. Work out the balance after day 5, in Summary!B4 - starting the running total from the real opening balance, not from zero.

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