Want to calculate the total of a large range of cells? Use an array formula. An array is a series of data in a row, column, or a combination of rows and columns. An array formula performs calculations on the data in one or more arrays, returning either a single or multiple results. Take this short course to learn more.

## Array formulas

Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results. Watch this video to learn more. (2:57)

## Use SUM, AVERAGE, and MAX in array formulas

An array formula can also return multiple values. Calculate totals, averages, and maximum values using the SUM, AVERAGE, and MAX functions. (4:24)

## Edit and delete array formulas

Editing an array formula requires special steps, and this video shows you what they are. You'll also see how to delete array formulas. (2:25)

A brief reminder of the key points in this course summary.

More courses available at Microsoft Office Training.