adding up a collum

Occasional Visitor

I am following the instructions with =SUM(  then dragging the cursor down the collum I need added, type in ) after that and press enter. so +SUM(D3:D14) I get 0 for the total.

What am I doing wrong? I'm on a Macbook.

Regards,

Scarlett

1 Reply

@scarlettmasselgmail Perhaps the "numbers" in the selected range are in fact texts that look like numbers. You can test that by entering a formula in an empty cell, for instance:

 

=ISNUMBER(D10)

 

or any other cell in the range that you are trying to sum. What do you get? If FALSE, the cell does not contain a number.