To add up a range of numbers in Excel 2010, you can use the SUM function. Here are some ways to use the SUM function:
-
Method 1: Use AutoSum: Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and youre done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
-
Method 2: Manually enter the SUM function: Type =SUM in a cell, followed by an opening parenthesis (. To enter the first formula range, which is called an argument (a piece of data the formula needs to run), type A2:A4 (or select cell A2 and drag through cell A6). Press Enter to get the total of the range.
-
Method 3: Use the plus sign: You can also use the plus sign as an addition operator in Excel, to get a sum of numbers. For example, =A1+A2+A3+A4+A5 is equivalent to =SUM(A1:A5) .
Its important to note that the SUM function can also be used to add individual values, cell references or ranges, or a mix of all three.