M

#### marsjune68

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