Extend formula capabilities with arrays

- [Voiceover] In Excel, there's a special kind of formula,…called an array formula.…And there's also special functions called array functions.…We're looking at a workbook called 11-Array…and the very first worksheet is called Arrays.…Many times, array formulas and functions deal with data…across multiple cells.…It's hard to define one of these exactly…until we see a few examples.…Now, in this list here…in columns B and C,…we've got unit sold, unit price,…and in column D, a simple formula…multiplying the two.…

Doing this…all the way down the column here,…then a total on the bottom.…Now, there could be times working with data like this…or larger amounts where we don't need the interim totals.…We just want the total price.…Now, there is a function that will let us handle this…it's not an array function.…I'm gonna alert you to it,…it's called sum product.…And in the example here,…we simple are going to be highlighting these cells…right here,…comma, and these.…And because of what the function does,…it's going to do the multiplication…