=SUM(A1:A10) adds a column. =AVERAGE(A1:A10) finds the average. =COUNT(A1:A10) counts the numbers. =MAX(A1:A10) and =MIN(A1:A10) find the largest and smallest. =A1-B1 subtracts.
Every formula starts with an equals sign.
← Resource Center
Quick-reference sheetMicrosoft Office
Excel Formula Quick Reference
The six formulas that cover most everyday needs.