I have the following table and cant get it to add right. I have tried Sum and
just adding the cells but it is always off by one cent.

304.63
0.00
0.00
0.00
0.00
0.00
29.57
0.00

334.21

I ahve all the cells invloved formatted the same.

HELP...
Alex

Try

=SUM(ROUND(A1:A10,2))

as an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
---
HTH

Bob

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



"Alex" wrote in message
...
I have the following table and cant get it to add right. I have tried Sum
and
just adding the cells but it is always off by one cent.

304.63
0.00
0.00
0.00
0.00
0.00
29.57
0.00

334.21

I ahve all the cells invloved formatted the same.

HELP...
Alex

It's all to do with decimal places, Try extending the number of decimals that
excel displays and I think you will see that Excel is getting it right.

If having the answer display like this is a problem then look at ROUND in
the help section.

Mike

"Alex" wrote:

I have the following table and cant get it to add right. I have tried Sum and
just adding the cells but it is always off by one cent.

304.63
0.00
0.00
0.00
0.00
0.00
29.57
0.00

334.21

I ahve all the cells invloved formatted the same.

HELP...
Alex

The problem is not in the formatting, but in the values. Re-format All the
values, including the sum as Number with 8 decimal places.


You should see that you will have to use the ROUND() function to get the
desired result.
--
Gary's Student
gsnu200708


"Alex" wrote:

I have the following table and cant get it to add right. I have tried Sum and
just adding the cells but it is always off by one cent.

304.63
0.00
0.00
0.00
0.00
0.00
29.57
0.00

334.21

I ahve all the cells invloved formatted the same.

HELP...
Alex