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 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. …
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.
September 21, 2009
Thank you for catching the mistake! It’s always annoying when you find a typo. In this case, I forgot the whole sentence
November 27, 2009
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
November 29, 2009
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.
December 9, 2009
Excellent post..Keep them coming
Thanks for sharing.