Try:

=SUM(ROUND(B1:B10,2))*A1

Which is an array formula and must be entered with Ctrl + Shift + Enter not
just Enter.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"G-man" wrote in message
...
I am using the round function round(A$1*B1, 2) for B1 to B10.
sum(B1:B10)*A1 does not equal the sum of round(A$1*B1to 10, 2)
It is off about $0.03. Is there a function that will round up or down to
get
the correct total?