This should be very easy for all of you computer whizzes - I have Column E. Column E has a bunch of numbers. I want Excel to automatically add all of those numbers together and put the total in Row #236. What do I need to do?

In cell E236 put: SUM(E&:E*), where & and * are the numbers of the first row of your numbers and the last row of your numbers. So, if you have a list from E1 to E235, it’d be SUM(E1:E235) in cell E236.

You need an equals sign before “SUM” to let Excel kow this os a formula, i.e.

=SUM(E1:E235)

Thanks both of you

- Go to the cell you want in row 236.
- Type in “=” (no quotes).
- Click the down arrow next to the box just to the left of the formula bar.
- Look for “SUM” in the drop down menu. If it isn’t there, look for it in the "Paste Function button drop-down mwnu.
- A box will open. Type in the cell range in the field lables “Number 1”, or click on the red arrow.
- If you clicked on the red arrow, go back to the cells you want to add, and select them all.
- If you didn’t click on the right arrow, click on “Ok”

Vlad/Igor

Assuming you’re wanting to sum an entire column of figures (not just the group or something), you can just click in any cell directly below the column of figures and then click the AutoSum toolbar button (which has Σ on it)