SUMIFS Providing Incorrect Total

[RudeClown]

Hi! This really isn't very complicated, but I'm finding that my SUMIFS formula is adding an extra penny to the total. I don't know if the issue will scale up or not with a larger dataset, but regardless, it needs to be accurate with three items on the list or three hundred. The correct answer in the below is $2.54, not $2.55. Any thoughts why it's not calculating correctly? Any background rounding going on that I can't see? The idea here, is the user will enter dates into G2 & H2, then I2 should add together any payout amounts from column E that falls on or between the dates entered, as noted in column A. I did notice, btw, that if I delete the data in row 5, it calculates correctly with only the row 3 & 4 data, but with the row 5 data, it adds an extra penny. Thanks for anything you may be able offer!

 

[Eric W]

Looks like a rounding issue. Is column E a formula? If so, the amounts aren't exact cents amount, but are just displayed to the 2 digit precision that shows. You can use one of the ROUND or CEILING functions around the E formula to get the actual value you want, then the SUMIFS should work ok for you.

 

[RudeClown]

Looks like a rounding issue. Is column E a formula? If so, the amounts aren't exact cents amount, but are just displayed to the 2 digit precision that shows. You can use one of the ROUND or CEILING functions around the E formula to get the actual value you want, then the SUMIFS should work ok for you.

Thank you for pointing that out! I tweaked the formula in column E with ROUND and that seems to have taken care of it. I truly appreciate your time in giving me a hand!