Array formulas

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

Inside this course:

Array formulas (2:57)
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.

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

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

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

More courses available at Microsoft Office Training.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!