thankyou MrShorty,
links have given me something to think about and a slight headache this early in the morning !!
can just about see how excel has trouble storing non integers in byte form but not sure why this doesn't cause the same errors in every column that is totalling similar currency figures. Maddening thing is this error crops up amidst other very similar calculations that show no problems.
also, thankyou Mark,
tried your array formula solution but didn't have much joy (not used to using the parenthesis formulae, so I might just be being a bit of a dunderhead).
The way I typed it, the formula looked like {=sum(a1:a77)*100)/100} and excel didn't like it, which I understand due to the unmatched ')'.
I tried variations but couldn't get these to work although I can see how it should work as regards converting the fractions to integers and back again.
tempted to revert to the round function as a last resort as I'm feeling slightly dense now
will check back tomorrow in case you've got the patience / time to post anything else for me.
Bookmarks