I have a range of cells (AC11:AC41) - I fill numbers in
this range every day. For this month there are 9 days of
data. In the rest of the cells there's a formula. So
there is a 0% in the remaining days. In cell AC43 I want
to calculate the average. Only problem, if I add the
full range it doesn't give me an accurate count because I
don't want to count the days that contain 0%. Another
problem, I could have had 0% on March 2 and/or March 5
etc.

What average formula do I use so it doesn't count the
days after the current date?
Thank you

=SUM(Range)/COUNTIF(Range,"0")


--

Regards,

Peo Sjoblom


"Karen" wrote in message
...
I have a range of cells (AC11:AC41) - I fill numbers in
this range every day. For this month there are 9 days of
data. In the rest of the cells there's a formula. So
there is a 0% in the remaining days. In cell AC43 I want
to calculate the average. Only problem, if I add the
full range it doesn't give me an accurate count because I
don't want to count the days that contain 0%. Another
problem, I could have had 0% on March 2 and/or March 5
etc.

What average formula do I use so it doesn't count the
days after the current date?
Thank you