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
|