Excel formulas cheat sheet

1. Excel Formulas Cheat Sheet
Functions Formulas Operators
SUM

=sum(A1+B1+C1)
=sum(A1:C1)
Use the formula above if you are +/-/* or /
more than two cells
=A1+B1
=A1:C1
Use the formula above if you are +/-/* or /
ONLY two cells

+ (add)
- (subtract)
* (multiply)
/ (divide)
MIN

=MIN(A1:A5)
Smallest number between A1 to A5


MAX

=MAX(A1:A5)
Largest number between A1 to A5


AVERAGE

=AVERAGE(A1:A5)
Average number between A1 to A5




Absolute Cell Reference: add $ sign before letter and number of cell. A1 becomes: $A$1
The quick key for Absolute Cell Reference is F4.