Column Totals not added correctly.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debby - 18 Aug 2005 00:11 GMT

I have a column in my spread sheet whose total at the bottom is not accurate.
I add up all the numbers in the column and come up with a different number,
usually only by a few pennies. the rows being added across to that column
contain a calculation for backing out tax from a total, that cell is then
added in with a group of other cells in the same row and subtracted from
another group of cells in the same row. Exp: =SUM(C29:F29)-(G29+H29). C29:F29
are numbers manually entered. G29 is the formula for backing out tax
=SUM(G29*0.061033) H29 is an number manually entered.
=SUM(C29:F29)-(G29+H29), is the entry formula for the column that is not
adding up properly. I entered the formula in the total area at the end of
that column by high lighting the colum and using the automatic calculation
from the menu bar. When the numbers in the column are added they do not total
up right.

Reply to this Message

Jerry W. Lewis - 19 Aug 2005 22:27 GMT

Formatting only affects the display, not the value of a number in a cell.
The cells you are summing contain fractions of pennies that accumulate to the
observed discrepancy. If you want them to only contain whole pennies, then
you need to choose how to handle those fractions, and then use the
appropriate function from among ROUND, ROUNDUP, and ROUNDDOWN.

It is not clear to me how this is causing Excel to crash. Otherwise the
"Worksheet Function" group would be a more appropriate location, and one that
would have gotten you a much faster response.

Jery

> I have a column in my spread sheet whose total at the bottom is not accurate.
> I add up all the numbers in the column and come up with a different number,
[quoted text clipped - 9 lines]
> from the menu bar. When the numbers in the column are added they do not total
> up right.

Reply to this Message