Total sum is zero when it should be adding multiple cells

  • Thread starter Thread starter Sld81
  • Start date Start date
S

Sld81

When I enter this formula: =SUM(D80,D73,D55) the cell I want it entered in
comes back with $ -. Not the total of the three cells. It seems so simple,
but it is just not adding them.
 
Hi

Use the ISNUMBER function on each of the 3 cells to see which of them is/are
not real numbers.

It could also be that number formatting is the culprit (on the cell with the
formula).
 
The "numbers" in those cell are text instead of numbers.
=D80+D73+D55
will coerce text to numbers. Alternately, you could reformat the cells to
accept numbers then reenter the values (formatting does not change cell
contents, just cell appearance). Another way to convert the cells to numbers
is to copy an empty cell, select the cells in question, and Edit|Paste
Special|Add.

Jerry
 
Back
Top