An Array Formula performs multiple calculations on one or more sets of values, the ‘array arguments’, and returns one or more results.

Entering an array formula:

  1. Select the cells where you want to see your results
  2. Enter your formula
  3. Press Ctrl+Shift+Enter. Excel fill each of the cells you selected with the result

Example

  A B C D E F G
1   CostCo Sams BigBlu HECO Chase  
2 Shares 500 300 700 450 600  
3 Price $10.00 $15.00 $12.75 $14.00 $18.00  
4              
5   Formula Result Notes
6   {=SUM(B2:I2*B3:I3)} $53,184 The formula multiplies the shares (cells B2 – I2) by their prices (cells B3 – I3), and then adds those results to create a grand total of 53,184

Note: The curly brackets, { and }, are not entered by the user. Excel applies these after the user presses Ctrl+Shift+Enter.