Excel formula problem

[bbismyhigh]

I am trying to add totals from various linked spreadsheets on a recap report, but when I put in the formula =sum(b3:b7) the total is not correct. it is a penny off. The totals from the linked pages are automatically brought accross to the recap report. Why is this happening?

I have windows XP and I am using Office 2010.

Thanks so much,

 

[Domenic]

Have a look here...

http://www.mcgimpsey.com/excel/pennyoff.html

 

[bbismyhigh]

Thank you so much for the answer. You're awesome!!!!

 

[Domenic]

You're very welcome! Thanks for the feedback!