Here is the scenario:

I have a column of 12 cells. Originally, I needed to
calculate the column avarage and I did this: SUM
(A1:A10)/12. Now, some of these cells are zeros and I need
to calculate the column avarage excluding them. let's say
that out of the 12 cells 3 are zeros. my formula would be:
SUM(A1:A10)/9. Because the number of cells that have zeros
is always changing I need a formula that identifies the
cells with zeros, subtracts it from 12 and divides the sum
to it.

Thank you

Use this as the denominator:

=COUNTIF(A1:A10,"<0")

marius wrote:
*Here is the scenario:

I have a column of 12 cells. Originally, I needed to
calculate the column avarage and I did this: SUM
(A1:A10)/12. Now, some of these cells are zeros and I need
to calculate the column avarage excluding them. let's say
that out of the 12 cells 3 are zeros. my formula would be:
SUM(A1:A10)/9. Because the number of cells that have zeros
is always changing I need a formula that identifies the
cells with zeros, subtracts it from 12 and divides the sum
to it.

Thank you *


---
Message posted from http://www.ExcelForum.com/

It works. Thanks a lot.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!