View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WH99 WH99 is offline
external usenet poster
 
Posts: 51
Default 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