Array

An array in Excel is a structure that holds a collection of values.

Then use theF9 keyto inspect the underlying array.

you’ve got the option to also use theARRAYTOTEXT functionto show how columns and rows are represented.

Setformatto 1 (strict) to see the complete array.

Inside SUM, the range resolves to an array of values.

Array formulas

Array formulasinvolve an operation that delivers an array of results.

The LEN function then generates a character count for each value and returns an array of 5 results.

TheSUM functionthen returns the sum of all items in the array.