In the workbook I use for electric meter readings one of the months one row
doesn't calculate correctly. I cannot figure out why. The rest of the
workbook calculates the way it should. This particular row is about $45 off
what the total should be. Anyone know how I can fix this?
Otto Moehrbach - 28 May 2008 20:21 GMT
Be more specific about what you have. A row doesn't calculate anything, a
formula does. What are the formulas you have? In what cells/columns? What
are in the other columns? Check the formats in the cells of the various
columns. A cell that is formatted as text will display a number if a number
is entered into it, but in fact Excel will take that number as text. Any
subsequent calculations with that "number" will not be correct. HTH Otto
> In the workbook I use for electric meter readings one of the months one
> row
> doesn't calculate correctly. I cannot figure out why. The rest of the
> workbook calculates the way it should. This particular row is about $45
> off
> what the total should be. Anyone know how I can fix this?
Gary''s Student - 28 May 2008 20:27 GMT
I would look at the two most likely sources of error:
1. A list of values was increased in size and the formula that referenced
the list was not updated to include the larger size
2. More likely - a value has been entered in a cell formatted for Text. The
value LOOKS like good, but actually has the value 0. Functions like
=SUM(A1:A100)
will not trap the error

Signature
Gary''s Student - gsnu200789
> In the workbook I use for electric meter readings one of the months one row
> doesn't calculate correctly. I cannot figure out why. The rest of the
> workbook calculates the way it should. This particular row is about $45 off
> what the total should be. Anyone know how I can fix this?