Did you know that Excel SUM is the function that people read about most? No wonder they decided to add a special button to the Excel ribbon that inserts the SUM function automatically. So, if you wanted to know "What is AutoSum in Excel?" you already got the answer. Continue reading
Comments on: How to use AutoSum in Excel
by Svetlana Cheusheva, updated on
Table of contents
Comments page 2. Total comments: 49
I have entered =SUM(H:H) into J2, expecting J2 to show a running total of everything entered into col H. This seems to work for values that are already in col H but does not update when I enter new values further down col H. How do I get J2 to show the "live" value of column H automatically each time something new is added to col H?
Hi Lawrence,
Most likely it's because your Calculation setting has been changed to Manual instead of Automatic. To fix this, go to the Formulas tab > Calculation group, click the Calculation Options button, and select Automatic.
assume I want b1 and a2 to sum themself automatic and the sum to appear on b2 what shoul I do
regads
Hi Devon,
Simply enter this formula in B2:
=SUM(B1, A2)
My name is dillip behera I excel in perfte
Alt+=, shortcut for autosum is not working. Pressing = while alt is on hold is zooming the screen.
How to resolve?
1CM
2CM
3CM
4CM
5CM
6CM
HOW TO CALCULATE
Bipin:
Do you want to count the number of entries or sum the numbers to the left of the "CM"?
I am trying to auto sum, a specific value to each cell in that column. For example, I have an "x" in column B2, B3, B4, and B5. In B6, I want it to automatically populate "8", scoring each "x" as 2 points. If I remove the "x" from B3, the scoring should automatically go down to "6" in B6.
What formula should I be using so that this happens? Also, I want to color code red a cell, when an "x" is put in both column B2 and C2 within the same row. Each row should have only one "x".
Thanks for your help!
Hello, Danielle,
to score 2 for every X in B2:B6, try this in B6:
=COUNTIF($B2:$B5,"x")*2
As for the cells coloured in red, you need to create the following conditional formatting rule:
=$B2=$C2
and apply it to =$B$2:$C$5
If you don't know how to create and use conditional rules, please take a look at our tutorial.
#Nice
Hello
I am having trouble trying to add up a row.
The problem is that i want to include a letter after the numbers but it comes up with error because of the letter.
How to fix this?????
Hello, Nathan,
SUM/AutoSum perform mathematical calculations with numbers only. They can't interpret your letter as a number, resulting in error. What you can do, is to sum up the numbers only and then enter you letter manually right beside your result figure (if it's a single letter you want to see, of course). If you have lots of numbers with letters, you can use our Remove characters tool to remove the text from the cells for further calculations. The last resort would be a special script, but we can't help you with it. However, you can try and ask around on MrExcel forum.
Hi Svetlana, I hope you are well.
what formula should I use that would minuse 3 from the value in N32 when I add 1 to O32? I'm new to excel.
Thanks in advance.
Mohsin
in N32 Cell
= Initial Value of N32-(3*($O$32-Initial Value of O32))
Let the Initial value of O32 =1
Let the Initial value of N32 =100
Then in N32 Cell
=100-(3*($O$32-1))
so when you add one to O32
I have just typed a price list of are different mobile homes. Now i need to add 15,000 euros to each individual price, can this be done on Exel? I am using an Macbook Pro. If this can be done how do i do it? Tried to do it many times with formulas but no success.
Hello Kim,
Supposing you have a price list in column A beginning with cell A2. Then, enter this simple formula =A2+15000 in, say B2, and copy it down to other cells in column B.