Excel Formulas Cheat Sheet

Functions Formulas OperatorsSUM =sum(A1+B1+C1)

=sum(A1:C1)Use the formula above if you are +/-/* or / more than two cells=A1+B1=A1:C1Use 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.