Adding columns

[Mojo1]

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.

 

[DRJ]

=Sum(B2:B34) is the right equation. Maybe you are typing it in wrong?

 

[Mojo1]

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]

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]

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]

What you need to do is highlight the cell B35 all the way to B2 and then press the sigma key to add it.