Thread: adding in multiple numbers when on cell is Blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OHNESORGE OHNESORGE is offline
external usenet poster
  
Posts: 12
Default adding in multiple numbers when on cell is Blank
I am adding multiple cells in a row that contain negative numbers as well as
cells that have no value in them at all.
EXample: C1=3,C2=(1),C3=blank cell,C4=sum of numbers
Question= C4 is comming up with !value# because C3 is not filled in, how do
I fix?
Reply With QuoteReply With Quote