2007-07-06 06:57:08 · 5 answers · asked by bar22bie 2 in Computers & Internet ➔ Software
Install it from the MS Office disc. ~
2007-07-06 07:04:56 · answer #1 · answered by Anonymous · 0⤊ 1⤋
Let's assume you have a column of numbers to add. They are in colum F and in rows 2 - 112 and you want the total in F 113. Go to cell F113 and type in =sum(F2:F112) and hit enter. The general command is =sum(xxx:yyy) means provide the sum in the range xxx to yyy where xxx is the cell to start the adding and yyy is the cell where it is to end.
If you wanted to add the total in columns F and G in rows 2 - 112, the command would be =sum(F2:G112).
If you wanted to add Row 10 columns B through G, the command would be =sum(B10:G10).
You can also use the tool bar's Sigma (Greek letter looking similar to E) and it will decide what to add. Be careful with this.
2007-07-06 07:03:50 · answer #2 · answered by GTB 7 · 0⤊ 0⤋
Either enter a formula =sum(a1:a3) or use the autosum button and make sure the correct cells are selected.
2007-07-06 07:00:49 · answer #3 · answered by Glennroid 5 · 0⤊ 0⤋
"=A1+A2" will add cells A1 and A2 and put the answer where the formula is.
2007-07-06 06:59:42 · answer #4 · answered by Barkley Hound 7 · 0⤊ 0⤋
Use the SUM() function
2007-07-06 06:59:59 · answer #5 · answered by Andy G 4 · 0⤊ 0⤋