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 in the rows.
Any ideas on how to do that?
| 525 | 686 |
| ... | ... |
| 279 | 375 |
| 247 | 346 |
| 538 | 908 |
| ... | ... |
| 0 | 0 |
| ... | ... |
| 52 | 64 |
| 0 | 0 |
- =if(Isnumber(Col1+col2);Sum(Col1+Col2);"...")
2 Replies
- =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.
