A question about Microsoft Excel.....?

Question

I need to figure out how to keep a total on Excel. For example, I could write the expenses down. I would put the total at the bottom. How do you program Excel to keep the total automatically? Please, if anyone knows, answer. I would greatly appreciate your help.

thank you ITpro. in a few hours, you will get the points. It was a hard decision, becauase I could have used everybody's answer, but in the end I chose the first one. The highlighting method also worked for me, so I thank all those people that responded with that.

Answer 1

=sum(a1..a20)

a1 is the cell of your first number
a20 is the cell of your last total.

Answer 2

While the answer seems chosen, I would like to add my 2 cents worth anywayfor your future reference/use. When you have a column of numbers you wish to total up - reference the cell immediately below the list of numbers, then go up to the toolbar where there is a button called 'Autosum' [tooltips will tell you this, looks like a math sigma (or a weird letter E)] Press this button once and it will generate the sum function command and all you will need to do is press enter.

Answer 3

Lemme wager, you're in a working laptop or laptop Literacy classification... possibly with the paintings Institute??? because of the fact whats humorous is it extremely is the right question of this weeks first project. weird and wonderful. "Week 3: Week 3 - W3: project one million communicate communicate question 3 examine Microsoft observe, Microsoft Excel, and Microsoft PowerPoint. while could you utilize each and every of those purposes? while are you able to apply those purposes interchangeably? provide examples and motives to help your answer."

Answer 4

Just highlight the whole column you want to total down to where you want the total to show, then click on the greek summing icon (like a reverse 3)

Answer 5

I agree to mn_mainframer.
Autosum (sigma) in Excel is a feature specially designed to answer your question. Simply select the cell which needs to be summed up and press Enter.

Answer 6

IT pro is correct,

An easy way to do it is to highlight the row/column that you want to add plus one additional cell where you want the total to appear. Then click the sigma button on the toolbar (the Greek capital E).

Answer 7

okay, first you have to find out where you want to put your total. If it is at the bottom of a list, then you want to start there. put your cursor on the box (like you want to write something in the box) then you will type in the formula. For example if you wanted the total of A1 - A17 then you put in the box sum=A1:A17

Answer 8

the easiest way is to us Autosum it's the button on your tool bar that looks like a letter M lying on it's side

Answer 9

if u know that your range is fixed then go to last cell & put the formula =sum(range)
if it is dynamic then better will be VBA (Visual Basic for Application)

Answer 10

highlight the boxes with one empty one at the botom or at theend and use your auto sum botton at the top