WorksheetFunction.Sum

[kamaflage]

Hi everyone,
I am sure that I must be doing something wrong however I am not sure what it is.

Can you please review the attached macro and explain why I am getting the below answer when the correct answer should be 0.
WorksheetFunction.Sum.error.JPG
Please select range A1 to B11 and then run the macro.

WorksheetFunction.Sum.JPG

Please Login or Register  to view this content.

[xlnitwit]

Hi,

It is due to floating point errors. You will see the same result if you enter =SUM(A1:A2,B9:B10) into a cell on the worksheet and show enough decimal places.

[kamaflage]

Thank you, because of the explanation i am able to modify to the below.

Please Login or Register  to view this content.