(Closed) How do I get the number row to add up on the bottom … in an excel document?

posted 8 years ago in Technology
Post # 3
Member
1080 posts
Bumble bee
  • Wedding: March 2010

You hit the sum button (its at the top and looks like a zigzag letter E)

Post # 4
Member
2695 posts
Sugar bee
  • Wedding: April 2010

Click on the last cell in the row or column and highlight from it up or over the cells you want it to add.  Once they are all highlighted look at the toolbar.  There should be a funking looking E or S shape click on it and it will add them. 

if that doesn’t work then click in the cell and type =SUM(a1:a10)

Post # 5
Member
1111 posts
Bumble bee

what i usually do

is type =sum(and drag along the column/row you want to add) in the cell you want the sum to show up in

so if you have a5-a20, it would end up as  =sum(a5:a20)

Post # 6
Member
3285 posts
Sugar bee
  • Wedding: November 2009

i love the formulas…i was just working on it this morning =)

Post # 8
Member
2695 posts
Sugar bee
  • Wedding: April 2010

The stuff inside your (  ) should be the first cell you want to add and then the last cell.  The : in between the two means to add everything in between.

 

Post # 9
Member
14186 posts
Honey Beekeeper
  • Wedding: June 2009

you can also search and insert formulas. I have to find tutorials still

The topic ‘How do I get the number row to add up on the bottom … in an excel document?’ is closed to new replies.

Find Amazing Vendors