This is a draft cheat sheet. It is a work in progress and is not finished yet.
Basic
=SUM(A2:A10) |
Adds the values in cells A2:10 |
=SUM(A2:A10, C2:C10) |
Adds the values in cells A2:10, as well as cells C2:C10 |
=MAX(A2:A10) |
Largest in range |
=MIN(A2:A10) |
Smallest in range |
=AVERAGE(A2:A10) |
Average in range |
Counting
=COUNT(A1:A20) |
Count Numeric cells in A1:20 |
=COUNTA(A1:A20) |
Count non empty cells in A1:20 |
=COUNTIF(A2:A5,"London") |
Count how many cells equals to "London" |
=COUNTIF(A2:A5,">=5") |
Count how many cells is at least 5 |
=COUNTIF(A2:A5,">"&B5) |
Count how many cells larger than B5's value |
|
|
Conditions
=IF(condition, true, else) |
|