Forum Discussion
Solved
Summing that recognizes zeros blanks/...
I would like to sum the below cross rows but be able to return the three dots of the rows being added have dots or zero if the rows being added have zeros and the sum if there are numbers to be added...
- =if(Isnumber(Col1+col2);Sum(Col1+Col2);"...")
=if(Isnumber(Col1+col2);Sum(Col1+Col2);"...")
Thanks, Geir, it works perfectly fine. For some reason, if I say Sum in that first part and not a plus, it doesn't work. Thanks a million.