SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods
See Mr Excel and Excelisfun calculate descriptive statistics: MIN, MAX, Standard Deviation, Average using three methods:
1) Data Analysis Toolpak Add-in, Descriptive Statistics
3) Functions and Defined Names
Functions: SUM, AVERAGE, STDEV.S, MIN, MAX
See keyboard shortcuts for Creating Defined Names From Selection and for entering Defined Names in Formulas and entering Functions from a drop down list.