How to calculate the sum of a vertical column in Numbers?

Question

Level 1

4 points

How to calculate the sum of a vertical column in Numbers?

I have a vertical column of numbers in the Numbers application. I want to get a total sum for all of the cells in the column. The cell in which I want to calculate this sum total is Row 119 and Column S. I have a field open in which I need to enter the formula for calculating the sum total. I am hoping to get a precise instruction. I am not very experienced with my Apple devices. Thanks.

[Re-Titled by Moderator]

Original Title: Calculating sums in Numbers

iMac 24″, macOS 26.0

Posted on Sep 21, 2025 03:33 PM

Reply

Answer 1

Top-ranking reply

6x6

Level 6

18,417 points

Sep 21, 2025 04:30 PM in response to Royster17

Assuming your data is in column S, use the following formula:

SUM(S1:S118)

If your data don't actually start at S1 (Row 1 of Column S) but at another row (let's say Row 2), use this formula:

SUM(S2:S118)

Reply

Answer 2

Sep 21, 2025 04:28 PM in response to Royster17

One method is to select column S rows 1 through 118 (e.g. drag mouse from 1 through 118 to highlight them) and then drag the Sum formula from the bottom left of the screen to row 119.

Another option is to click in column S row 119 and type "= sum" and then use mouse to select rows 1 through 118 in that column.

Also see: Quickly calculate a sum, average, and more in Numbers on Mac - Apple Support

Reply