Jan 17 2022 03:53 AM
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
Jan 17 2022 04:40 AM
@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.