Forum Discussion
Excel - adding numbers with decimal points
good day i am battling with the "sum" function - i am trying to add (sum) numbers with decimal points in a column.
Sbu_M1035 Let's say the numbers are in cells B2 to B10 and you want to sum them showing the result in B11. In B11 type =SUM(B2:B10) and press enter.
Many thanks for your kind response!
I tried your suggestion.....seems to work when numbers are uniform....if you have a mix of whole numbers and ones with decimal points, it does not seem to work.
Strangely, when I changed the decimal points for commas, bingo I could add/sum mixed whole numbers and those with commas....
could add
