Hi,

You can try =E1/countif(D$1:D1,"0"). This will ignore the 0's in the
denominator.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"marsjune68" wrote in message
...
A B C D E F

ROW1 DATE SCORE MATH AVERAGE
ROW2 1 1/2/2009 0 0 0
ROW3 2 1/2/2009 75 75 75
ROW4 3 1/2/2009 135 213 107
ROW5 4 1/2/2009 99 312 104
ROW6 5 1/2/2009 0 0 0
ROW7 6 1/2/2009 149 149 30


THE MATH:
=IF(D1=0,0,D1)
=IF(D2=0,0,D2+E1) and so on

THE AVER
=E1/B1
=E2/B2 and so on

I want to be able to calculate the average score in a running total. But I
do not want the running total to count "0" in the score colum.
Right now id someone scores a zero it blow the average. I do not care to
count a zero in the score colum. Below is how I want it to work.
In row 5 the person scored a zero and it did not impact the average. But
with the way I am doing the formula it is changing the 115 average to a
30
average. For my purposes 115 is the average not 30. How can I do this?


A B C D E F

ROW1 DATE SCORE MATH AVERAGE
ROW2 1 1/2/2009 0 0 0
ROW3 2 1/2/2009 75 75 75
ROW4 3 1/2/2009 135 213 107
ROW5 4 1/2/2009 99 312 104
ROW6 5 1/2/2009 0 0 0
ROW7 6 1/2/2009 149 461 115