How do I 'SUM' a column corrected to 2 decimal places from 3
 

I have two columns of data - in column A are quantities of goods (which cost
..025p each), in Column B is the total cost, arrived at by "=A1*.025" etc.
Column B is corrected to 2 decimal places to give a usable finance figure,
but if I SUM column B, instead of adding the figures shown, it adds the
uncorrected amounts (ie 3 decimal places) which ends up in a total which
doesn't match the visible figures. This sounds like it should be quite
simple to correct, I just don't seem to be able to find the answer. I am
using Office 2003 and column B is formatted to exclude zero figures. Hope I
have explained clearly!

How do I 'SUM' a column corrected to 2 decimal places from 3
 

You could expand the formula in B to "=round(A1*.025,2)" so that each
individual line is then accurate to 2 decimal places and the total will be
also.

"barkingmad" wrote:

I have two columns of data - in column A are quantities of goods (which cost
.025p each), in Column B is the total cost, arrived at by "=A1*.025" etc.
Column B is corrected to 2 decimal places to give a usable finance figure,
but if I SUM column B, instead of adding the figures shown, it adds the
uncorrected amounts (ie 3 decimal places) which ends up in a total which
doesn't match the visible figures. This sounds like it should be quite
simple to correct, I just don't seem to be able to find the answer. I am
using Office 2003 and column B is formatted to exclude zero figures. Hope I
have explained clearly!

How do I 'SUM' a column corrected to 2 decimal places from 3
 

I don't quite see the problem (they will all be multiples of a quarter,
which can only sum to 2 dec pl as I see it), but maybe this helps

=SUMPRODUCT(ROUND(B1:B20,2))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"barkingmad" wrote in message
...
I have two columns of data - in column A are quantities of goods (which
cost
.025p each), in Column B is the total cost, arrived at by "=A1*.025" etc.
Column B is corrected to 2 decimal places to give a usable finance figure,
but if I SUM column B, instead of adding the figures shown, it adds the
uncorrected amounts (ie 3 decimal places) which ends up in a total which
doesn't match the visible figures. This sounds like it should be quite
simple to correct, I just don't seem to be able to find the answer. I am
using Office 2003 and column B is formatted to exclude zero figures. Hope
I
have explained clearly!