Calculate Totals with AutoSum for both across and down a table of number : AutoSum « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. AutoSum
Hold Control Key and Drag your mouse to select two ranges
Then select A6 to B5
Click the Formulas tab. 
           Click the AutoSum button.
Click the Formulas tab. Click the AutoSum button.
Check the result.
Click the Enter button on the formula bar, or press Enter.








6.2.AutoSum
6.2.1.Calculate Totals with AutoSum for a rangeCalculate Totals with AutoSum for a range
6.2.2.Calculate Totals with AutoSum for both across and down a table of numberCalculate Totals with AutoSum for both across and down a table of number
6.2.3.Calculate with Extended AutoSumCalculate with Extended AutoSum