averages formula
 

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?

=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


"Gerald" wrote in message
...
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?