Thread: Sumif problem with zero value and blank cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Wildman[_2_] Joe Wildman[_2_] is offline
external usenet poster
  
Posts: 30
Default Sumif problem with zero value and blank cells
Eg.

="State: "&IF('Sheet1'!$C$6="","",'Sheet1'!$C$6)

Use ,""

Reply With QuoteReply With Quote