I've found an interesting situation where suming a list of values with SUM and SUMPRODUCT is returning me slightly different values. The SUM is correct (0), while SUMPRODUCT is giving non-zero (9.09495E-13).
The values in my column are C2:C5:
[TABLE="width: 74"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]28090.46[/TD]
[/TR]
[TR]
[TD="align: right"]-8427.14[/TD]
[/TR]
[TR]
[TD="align: right"]-16854.28[/TD]
[/TR]
[TR]
[TD="align: right"]-2809.04[/TD]
[/TR]
</tbody>[/TABLE]
With formulae:
=SUM(C2:C5)
=SUMPRODUCT((C2:C5)*1) [This is a much simplified version of my formula as a result of my issue hunting]
I've been able to recreate it with different numbers, and by manually typing the numbers to remove any strange copy/paste issue. But equally I've used some numbers which don't have the issue (100.44, -50.22, -50.22)
I'm running Excel 2016 MSO (16.0.8201.2209) 32-bit, if that helps...
Anyone got any ideas why it's happening?
The values in my column are C2:C5:
[TABLE="width: 74"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]28090.46[/TD]
[/TR]
[TR]
[TD="align: right"]-8427.14[/TD]
[/TR]
[TR]
[TD="align: right"]-16854.28[/TD]
[/TR]
[TR]
[TD="align: right"]-2809.04[/TD]
[/TR]
</tbody>[/TABLE]
With formulae:
=SUM(C2:C5)
=SUMPRODUCT((C2:C5)*1) [This is a much simplified version of my formula as a result of my issue hunting]
I've been able to recreate it with different numbers, and by manually typing the numbers to remove any strange copy/paste issue. But equally I've used some numbers which don't have the issue (100.44, -50.22, -50.22)
I'm running Excel 2016 MSO (16.0.8201.2209) 32-bit, if that helps...
Anyone got any ideas why it's happening?