Administration and Executive AssistantTier 820 minintermediate

TOCOL and Blank Cells

Count how many readings were actually taken, not how many slots exist in the grid.

What you will learn

• Use TOCOL to flatten a 2D range into a single column
• Explain what TOCOL's ignore_blanks argument controls
• Recognise that counting a flattened list without it overstates the count by the number of blank slots

Excel skills

TOCOL · Array Formulas

The task

Readings were taken across three departments over four weeks, but not every slot was filled in. Work out how many readings were actually taken, in Summary!B3.

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