numbers is adding incorrectly (over adding)
Hello
I have a 25 values, they are formatted as numbers not text
when I drag down the column I get sum 983.88
when i put in a formula =sum E33:E140 the result is 10,327.66
I copied the values to a new sheet and when I put in a formula =sum B2:B26 the result is 983.88
I put in the sum formula in a different column on the first sheet and still got too large a result
the sheet was imported from a garmin gps unit
So what is going on in the background that is giving me bizarre results?
this is the group of values they represent miles traveled. I have to filter out CT state miles monthly
6.72
13.66
6.94
14.42
16.12
108.09
12.82
37.40
83.59
13.35
12.45
56.46
67.24
31.29
33.22
35.84
49.59
98.76
83.68
6.79
83.33
13.38
6.67
59.03
33.04
MacBook Pro 15″, macOS 12.1