averages formula

[Guest]

i have a column, A1 - A10. Cell A11 is the average of all those numbers in
those cells. How do i manipulate the formula so the average doesn't include
the numbers in cells A4 and A8?

 

[Anne Troy]

=AVERAGE(A1:A3,A5:A7,A9:A10)

If you are trying to exclude zero values, you may want a different formula,
such as:

=SUM(A1:A10)/COUNTIF(A1:A10,">0")
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com