Replacing 0 with blank in formulas

**greyscale** · 06-23-2010, 08:53 PM

On the attached document, we have a rolling average for the most recent 12 months in column AF. Data in rows 2-8 are populated from cells in rows 18-32. Data is populated at the end of each completed month so at present, the rows 2-8 are appearing as 0. This is knocking out the 12 month average so I need to find a way to make them return as blank until such time as they are populated. Does anyone know how I can do this? I have been trying different options in column N with no success except that ISBLANK appears to work but only if I am referencing just the one cell and am not attempting a calculation.

**shg** · 06-23-2010, 09:04 PM

Maybe in N2, =IF(COUNT(N18:N32), SUM(N18:N32), "")

**greyscale** · 06-23-2010, 10:15 PM

Thanks shg! That's works perfectly for the formulas that sum. Now I just have to figure out what to do with the formulas that add nonsequential cells (N3 & N4). Any ideas on that one?