View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default suming blank cells

Sounds like there may be, say, " " in the cell. So, if (cell1="
",cell2,if(cell2="",cell1,cell1+cell2))

"Jase" wrote:

I am trying to add 2 cells together. Sometimes 1 of the 2 cell sthat I am
trying to add together is blank. When one of the cells is blank it is not
returning an answer for me, any way around this?

thanks,

JAse