# Thread: Excel 2010 Average Formula Changes

1. ## Excel 2010 Average Formula Changes

We have a worksheet with 2 sets of 4 columns of numbers. We have a formula to average each set of 4 columns.

The first average is =AVERAGE(E9:H9) in column M and the second average is in column N =AVERAGE(I9:L9).

When we start typing numbers in columns e through h the average formula displays the correct average, but when we continue typing a number into column i, the average formula in column M changes to =AVERAGE(E9:I9). If you continue typing into j9, k9, and l9, the formula changes to =AVERAGE(E9:L9). The average formula in column N does not change.

Our current work around is to insert a column to separate the two ranges for the formulas.

Does anyone know why this is happening to the AVERAGE formulas? The SUM function will do the same thing.

2. In Excel Options, in the Advanced section, you need to uncheck the 'Extend data range formats and formulas' option.

3. Thanks, Rory. I had hoped it was something easy.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•