printing without zeros showing in a cell with formulas

J

John

I've created a workbook that totals 5 worksheets (for Monday thru Friday) on
a 6th worksheet that is printed and posted weekly. However, because there is
a formula in each cell on the weekly sheet, a zero appears in all of the
cells which makes the sheet being posted look too too busy... Is there a way
to have the weekly worksheet leave all cells blank unless there is actual
data pulled?
 
G

Gord Dibben

Trap for no data or zero in source cell(s).

=IF(Sheet1!A1=0,"",Sheet1!A1)

=IF(Sheet1!A1="","",Sheet1!A1)

=IF(SUM(Sheet1:Sheet5!A1:A10)=0,"",SUM(Sheet1:Sheet5!A1:A10))


Gord Dibben MS Excel MVP
 
P

Pete_UK

Another way is to apply conditional formatting to the cells in the
summary sheet, such that if the cell content is zero, change the
foreground colour to the background colour (usually white).

Hope this helps.

Pete
 
Top