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?
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?