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

[daveyc18]

regular sum =

25,647,308,807.4172 sumif =

<tbody>
</tbody>

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