© 2011 Ugur Akinci
You can perform 5 very useful arithmetic operations on any column or row of numbers by using the AUTOSUM function.
Consider the following hypothetical data:
You can perform all 5 frequently used functions by clicking on the AUTOSUM button on your ribbon:
To SUM a ROW (or COLUMN), click and select the CELL at the end of the ROW (or COLUMN) and then click AUTOSUM > SUM:
Click the CHECK MARK on the FORMULA BAR to execute the operation:
To AVERAGE a ROW (or COLUMN), click and select the CELL RANGE and then click AUTOSUM > AVERAGE:
To calculate the MAX and MIN values, select the CELL at the end of the ROW (or COLUMN) and then click AUTOSUM > MAX or MIN:
To COUNT, select the CELL at the end of the ROW (or COLUMN) and then click AUTOSUM > COUNT . Click the CHECK MARK on the FORMULA BAR to execute the operation:
Is there a way to average column b and column e but not columns c and d?