sum if doesn't equal regular sum????

[daveyc18]

regular sum = [TABLE="width: 161"]
<tbody>[TR]
[TD] 25,647,308,807.4172


sumif =[/TD]
[/TR]
</tbody>[/TABLE]
25,647,308,807.4171


number formats are the same...i take the difference between the two numbers to several decimal places....Excel says "0.000000000000..."

i check to see if they equal each other by A1=B1....excel says "FALSE!"

granted, it's a minor differences but it's bugging the hell out of me

why is this happening?!?!?!

 

[MARK858]

Without seeing your data (which means we are only guessing) maybe....

https://www.microsoft.com/en-us/mic...y-does-excel-give-me-seemingly-wrong-answers/

 

[daveyc18]

Without seeing your data (which means we are only guessing) maybe....

https://www.microsoft.com/en-us/mic...y-does-excel-give-me-seemingly-wrong-answers/

ya sorry i cant upload the data....but....i think you're right