More than 5 averages

[That's Confidential]

i want to work out the average of more than 5 cells. They are now in a
column or in a row, so any ideas? I think the limit is 5

 

[Peo Sjoblom]

No there is no specific limit except 1024 characters for a formula, there is
normally 30 is you use

=AVERAGE(A1,A3,A5 and so on but that can be overcome by using

=AVERAGE(((first 30 cells),next),and so on

 

[Paul B]

I don't think there is a limit for average, use something like
=AVERAGE(A1:A20), or something like
=AVERAGE(A1,A4,A6,A10)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[That's Confidential]

Got it!

Thanks

PS: Isn't it easy when someone tells you how to do it?