basic numbers help

Go to the cell below the col of numbers with the keyboard open showing characters.

type =

then in the formula box next to the red X type

sum

then swipe up the col of numbers.

This will put a blue box round the numbers and the address in the formula box eg B6:B12

The blue box should surround all the number you want summed up.

Hit return and you are done. The cell now show the sum of the numbers.

Check out this you tube for more how to use Numbers https://www.youtube.com/watch?v=-XCkLnIPaL4

Just a point of clarification. Numbers does not have "boxes"; tables in Numbers have "cells".

Also in Numbers one would rarely use a range reference like B2:B14. One would define row 15 as a Footer Row and in B15 put =SUM(B).

An easy way to define a Footer Row is click the row number on the left and choose Convert to Footer Row from the dropdown that appears.

SG

I'd think of it as use Footer Row first with a simple formula addressing the entire column.

And, alternatively when there is no other way, use the more complicated range address common in Excel.

See the templates at File > New in your menu for many examples of column sums.

SG

assuming you want to sum the values in column A:

select the cell where you want the sum, then type:

=sum(A)

then type the <return> key

Hi nkmt,

Some confusion here.

Gannett's reply refers to Numbers for iOS

SG's reply refers to Numbers for Mac.

Both are correct! Please tell us what OS you are running.

Regards,

Ian.

In B15 use a range address to cover the cells to be summed.

=sum(B2:B14)

Alternatively use footer mechanism described elsewhere.