Formula Question

[sondriven]

I have a column with 12 cells that have this formula in each cell. (I5-H3)/H3/Countif(I5,">0")
The symbol #DIV/0! appears in each cell until a number is inserted.
What I need is a zero (0) or different formula in each cell so I can collect a running average from the data that is placed into each cell over a period of time. Is this possible?

 

[just_jon]

I have a column with 12 cells that have this formula in each cell. (I5-H3)/H3/Countif(I5,">0")
The symbol #DIV/0! appears in each cell until a number is inserted.
What I need is a zero (0) or different formula in each cell so I can collect a running average from the data that is placed into each cell over a period of time. Is this possible?

Would changing your formula to --

=(I5-H3)/H3*(I5<>0) or

=IF(N(I5),(I5-H3)/H3,0)

work ?

 

[sondriven]

I'll give it a try and let you know. Thanks.