How to Make Sums in Excel 2010

1. Open the Microsoft Excel 2010 spreadsheet that contains the numbers you want to add together.
2. Click on an empty cell in the spreadsheet, where you want the summation to appear. Type the equals sign into the cell to start a formula.
3. Enter 'SUM(' if you want to add together a number of cells. Type in the column letter and row number of the first cell that you want to include. Place a colon after this cell reference if you are adding together a continuous range of cells, then type in the last cell in the range. Place a comma after the first reference if the selected cells are not continuous on the spreadsheet, and enter in the second cell reference. Continue adding commas and cell references until you have entered all of the cells you want to add together. Enter a close parenthesis and press 'Enter.' For example, if you want to add the cells from 'A1' to 'B10,' enter: '=SUM(A1:B10).' If you want to add just 'A1' and 'B10,' enter '=SUM(A1,B10).' If you want to add 'A1' through 'A10,' but include 'B10' as well, enter '=SUM(A1:A10,B10).'
4. Enter 'SUMIF(' if you only want to add together some of the cells, based on the values of adjacent cells. Type in the first cell in the range that you want to check for a given criteria, then place a colon followed by the last cell in the range of cells. Type in a comma, then enter the value that you want to check for in the range of cells. This can be a simple number, a piece of text enclosed in quotes, or a cell reference. Type in another comma, then type in the range of cells that you want to add together if the cells qualify given your condition. So if you entered '2001' as your criteria value, Excel will look through the first range of cells and whenever it finds '2001,' it would add together the corresponding cell in the second range of cells. Type in a close parenthesis and press 'Enter' to complete the formula. For example, if you want to check cells 'A1' through 'A10' for the value '23,' and then add together the corresponding cells in the range of 'B1' through 'B10,' enter: '=SUMIF(A1:A10,23,B1:B10).'
5. Type 'SUMIFS(' into the cell if you want to sum together a range of cells based on multiple criteria. SUMIFS is similar to SUMIF, except the arguments are arranged in a slightly different order. Type the range of cells that you want to sum together into the formula, then enter a comma. Type the range of cells to check for a criteria, followed by a comma and the criteria itself. Enter another comma and continue to add criteria ranges and criteria until you have entered all data. Place a close parenthesis at the end of the formula and press 'Enter.' To add together cells 'A1' through 'A10' whenever '23' appears in column 'B,' and '25' appears in column 'C,' enter: '=SUMIFS(A1:A10,B1:B10,23,C1:C10,25).'