G
Guest
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.
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.