Forum Discussion
Excel Sum function
Fullname: Mei Cheung Contact email: Email address removed Contact numbers: 07872160641 Reference chat case: 1034231325 Issue: I cannot use SUM() function properly. I have copy & pasted sums from...
meicheung Can't really tell why this problem occurred after upgrading to MS365. Had a brief look at the file and noted two things. The "numbers" in column H contain leading spaces and the negative numbers have a CR prefix. You need to get rid of these so that they become real numbers with which you can calculate. Have used Find&Replace (ctrl-H) to do just that.
The end result is in column K.