The Microsoft Excel Sum command is a very useful command when you need to add up a row or column, or even separated cells or separated ranges. There are a few different ways of inputting this and both of the ones I will show you are right. Different, but right, just a matter of which is your preference.

The first one is manual inputting the information. As always, start an Excel formula with an equals sign *=*, and then a what you want it to do: *=sum(a1:a4)* this will add all the cells from A1 all the way to cell A4. It will give you the total of these four cells. If you need to sum cells that are not connecting you can type *=sum(a1,a4)* this will give you the total of cells A1 and A4 only. And you can add just about as many different cells as you need for your formula.. ie. *=sum(A1,A4,A6,A8,B3,B8)* etc, etc. And this works for ranges that are separated * =sum(A1:A4,C2:C5)* will add from cell A1 through to A4 and C2 thorough C5.

The second method is to type in the first part of the formula and then click the mouse on the cells you want to include while holding the right mouse button down. *=sum(* and then use the mouse to click on cell A1 and hold the right mouse button down and drag the broken selection square down to cell A4, then close the formula with *)* this will give you the same as typing in the same formula. *=sum(a1:a4)*.

Lets go a step further and include two ranges of cells you want to include in the formula, start with* =sum(* and then use the mouse to select A1 and drag to A4, now press the ctrl button on the keyboard and then click on cell C2 and drag to cell C5, close the formula with a *)* and you are done, the formula Excel places should look like* =sum(A1:A4,C2:C5)* exactly the same as if you would have typed it in manually… pretty sweet huh?

No give it a try with some thing and just see for yourself how quickly you will be doing it without much thought at all.

Really liked what you had to say in your post, Excel Sum Command | My Spreadsheet Assistant, thanks for the good read!

— Oscar

http://www.terrazoa.com