Sum value incorrect

Hello Liz,

Thank you for your question regarding Excel SUM values not adding up correctly.

Since I do not have access to your data I cannot tell why Excel produces a different answer to your calculator.

Try selecting all the cells you are referring to and increase the decimals to 2 places. Are the figures still whole numbers as in your enquiry? Or, do they have values after the decimal point? If there are values after the decimal point then Excel has added the values correctly.

If this has answered your question please let me know...

...if not, then please send me a copy of your worksheet only showing those lines mentioned in your question. My email address is:

rl@stl-training.co.uk


Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer