More than 5 averages

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

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
 
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
 
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 **
 
Back
Top