Show cell empty when 0
 

I have the following formulas:

Down column B:
=SUMPRODUCT(--(MONTH(MAIN!$A$10:$A$4999)=MONTH($G$1)),--(DAY(MAIN!$A$10:$A$4999)=DAY($A1)),MAIN!$D$10:$D$4 999)

Down column C: C1 =B1 then C2 onwards =SUM(C1+B2)

How do I get both columns to show an empty cell if the figure is zero?
--
WH99

Show cell empty when 0
 

"WH99" wrote in message
...
I have the following formulas:

Down column B:
=SUMPRODUCT(--(MONTH(MAIN!$A$10:$A$4999)=MONTH($G$1)),--(DAY(MAIN!$A$10:$A$4999)=DAY($A1)),MAIN!$D$10:$D$4 999)

Down column C: C1 =B1 then C2 onwards =SUM(C1+B2)

How do I get both columns to show an empty cell if the figure is zero?
--
WH99

Look at the custom options in format cells. You need to create something
like this:

'#,##0;-#,##0; '

without quotes. The first & second entries format positive + negative
numbers. The third formats zero - in this case it is a space. Replace the
first 2 with whatever you want (see the custom list if you need date formats
etc.