AutoSum function in Excel
Quick Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just about every spreadsheet can benefit from incorporating the AutoSum function. Lets Begin To begin, let’s start with a list of data we are looking to sum. Use the AutoSum function to …
Quick Overview
The AutoSum Function is by far one of the most useful features in all of Excel. Just about every spreadsheet can benefit from incorporating the AutoSum function.
Lets Begin
To begin, let’s start with a list of data we are looking to sum.
Use the AutoSum function to count the selected items in the grocery list from B3 to B9. In Cell B11, enter the formula: =SUM(B3:B9)
Let’s quickly dissect the syntax. We are telling Excel to add all of the amounts in the range B3 to B9 and display the total in Cell B11.
While holding the CTRL button, you can select various cells, or a range of cells to Sum.
Examples:
=SUM(B3:B9) – Result $28.51
=SUM(B3:B4,B8:B9) – Result $21.27
If you have an questions, please feel free to comment below.
[...] use the AutoSum function to count the selected items in the grocery list from column [...]
Thank you for catching the mistake! It’s always annoying when you find a typo. In this case, I forgot the whole sentence
Is it also possible to add items later? Lets say I want to add Vegetables.
I’ll add “Vegetables” to A10 and “$7,00″ to B10.
Is it possible that “Total#” jumps to row 12 and the sum is auto-adjusted in B12? So that I can continue adding items?
Thanks
Hi David,
Yes, just right click row number 10 and select Insert. Add “Vegetables” in cell A10 and “$7.00″ to B10. Inserting a row will automatically adjust the lines without messing with the Sum function.
Excellent post..Keep them coming
Thanks for sharing.
Instead of entering formula manually =SUM(B3:B9), place the cell selector beneath the last figure or you can select a range say B3 to B12 and then click HOME tab and then click “?” at editing group located at the right most of the ribbon in Excel 2007, you will get the formula entered by the Autosum. You can also count numbers, average, maximum, minimum and many more function in “?”.