=average

**mick2** · 07-13-2009, 06:08 AM

Hi,

I am trying to AVERAGE an Open-Ended (entire) column, while keeping the first 4 cells, "Out of the loop!"

Example:

=AVERAGE(E:E) less cells E1 through to E4, inclusive...

Any suggestions, please?

Cheers,

Mick2

**martindwilson** · 07-13-2009, 06:27 AM

=(sum(e:e)-sum(e1:e4))/(count(e:e)-4)

**mick2** · 07-13-2009, 06:43 AM

Hi Martin,
I tried your suggestion, but it didn't return the correct average.

Thanks,
Mick2

**arthurbr** · 07-13-2009, 06:54 AM

Maybe =average(e5:e65535) or use a dynamic range

**mick2** · 07-13-2009, 07:46 AM

Hi Arthurbr,

Thanks for your response, which works perfectly!

Cheers,
Mick2

**arthurbr** · 07-13-2009, 08:35 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save