Adding columns

Mojo1

Board Regular
Joined
Mar 6, 2003
Messages
148
What do I do to add cells B2 thru B34 in a column?
I have tried =SUM(B2:B34) and this does not work at all when I put it in the formula bar for cell B35.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

DRJ

MrExcel MVP
Joined
Feb 17, 2002
Messages
3,853
=Sum(B2:B34) is the right equation. Maybe you are typing it in wrong?
 

Mojo1

Board Regular
Joined
Mar 6, 2003
Messages
148
Tell me where I need to put eh formula =SUM(B2:B34) in order for it to add all the cells above it?
Obviously I am doing something wrong. I yped it in exactly as you sent it to me.
 

DRJ

MrExcel MVP
Joined
Feb 17, 2002
Messages
3,853
It doesnt matter where you put the equation. It can be in any cell far away if you want. What happens when you input the equation? Do you get an error? If so what is it.

Also just for the heck of it try the auto sum. Select cell B35 and press the sigma button on the standard toolbar. See what equation it puts in there.

I think I know what it is if you get the #Name? error. What are your reference style?

Tools | Options | General

Is R1C1 checked?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,916
Office Version
  1. 365
Platform
  1. Windows
Are you sure that your values you are summing are entered as numbers and not as text? If they are entered as text, the SUM won't work.

You could convert the column to numbers using Text-to-Columns (under the Data menu).
 

Mojo1

Board Regular
Joined
Mar 6, 2003
Messages
148
What you need to do is highlight the cell B35 all the way to B2 and then press the sigma key to add it.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,327
Members
414,053
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top