How do I add a column in MS excel?!?!

soon2BMrsMcD Posted: Apr 24, 2008 08:44 AM

How do I add a column in MS excel?!?!

I typed in how many guests were invited under each name and I want to count how many guests were invited total. Thanks in advance!!

wifetobe Posted: Apr 24, 2008 08:45 AM

Re: How do I add a column in MS excel?!?!

RIGHT CLICK . THEN CLICK 'INSERT' 'ADD COLUMN'

THERE YA GO.

soon2BMrsMcD Posted: Apr 24, 2008 08:47 AM

Re: How do I add a column in MS excel?!?!

Posted by wifetobe

RIGHT CLICK . THEN CLICK 'INSERT' 'ADD COLUMN'

THERE YA GO.

I want to add up a column, not add a colum

SparkyandAng Posted: Apr 24, 2008 08:50 AM

Re: How do I add a column in MS excel?!?!

=sum(beginning cell you want to start from : ending cell)
for example:

=sum(B1:B234)

kimnsteve Posted: Apr 24, 2008 08:52 AM

Re: How do I add a column in MS excel?!?!

highlight the column and hit the sum button on top ...

soon2BMrsMcD Posted: Apr 24, 2008 08:53 AM

Re: How do I add a column in MS excel?!?!

thanks ladies!!!!!!!!!!!

total=402!!!!!!!!!!!!!!!!!!!!

But that's including people that were invited with guests and I KNOW they are not bringing them!!

SparkyandAng Posted: Apr 24, 2008 09:06 AM

Re: How do I add a column in MS excel?!?!

Posted by soon2BMrsMcD

thanks ladies!!!!!!!!!!!

total=402!!!!!!!!!!!!!!!!!!!!

But that's including people that were invited with guests and I KNOW they are not bringing them!!

That number definitely made me raise an eyebrow!

It's a large group but I think it's awesome that you have that many people that want to help celebrate with you.