Thread: sum if statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim Shelton at PDC Kim Shelton at PDC is offline
external usenet poster
  
Posts: 16
Default sum if statement
My formula in Column D should read =sum(d6+c7=d7) but if c7 is blank then i
want the answer to be blank in column D7

column
C6 D6
5 10
c7 D7
0 leave blank.(not even a zero)


Reply With QuoteReply With Quote