how get sum in numbers

Question

hiltraut Author

Level 1

4 points

how get sum in numbers

how do i get sum in numbers

iMac 21.5″, macOS 10.14

Posted on Feb 27, 2021 10:55 AM

Reply

Answer 1

Top-ranking reply

Barry

Level 9

60,023 points

Feb 27, 2021 11:22 AM in response to hiltraut

Use the SUM() function.

In the above example, columns A and B play no part in this calculation, so I've hiden them.

Click on cell C10 to select it.

Press = to open the Formula Editor.

Type sum, then click that word to change it to the appearance above (with a grey lozenge where this one says C2:c7)

Select cells C2 to C7

Click the green checkmark to confirm the formula and close the editor.

Regards,

Barry

Reply

Answer 2

hiltraut Author

Level 1

4 points

Feb 27, 2021 12:22 PM in response to Barry

Barry, thanks again, I think I got it now. I had overlooked that the cells were formatted wrong, e.g. text instead of numbers, and now it works like you suggested.

Hiltraut

Reply

Answer 3

hiltraut Author

Level 1

4 points

Feb 27, 2021 11:52 AM in response to Barry

I did it several times, but always get a wrong result. I click on cell to select it (for sum to appear later), I press "=", and formula Editor appears, I type "sum", click the word, and next to it the grey lozenge appears which reads "value", and it will not let me "select" the cells I want added. And if I add one by one I get wrong result. What do I do wrong?

Reply

Answer 4

Barry

Level 9

60,023 points

Feb 27, 2021 6:19 PM in response to hiltraut

" I had overlooked that the cells were formatted wrong, e.g. text instead of numbers,"

Thst would do it!

Thanks for the explanation.

Regards,

Barry

Reply

how get sum in numbers

Similar questions