BASIC FORMULAS AND FUNCTIONS
Basic Formulas:
SUM:
Adds up values in a range of cells.
- Formula: =SUM(range)
- Example: =SUM(A1:A10) adds up the values in cells A1 to A10.
AVERAGE:
Calculates the average of values in a range of cells.
- Formula: =AVERAGE(range)
- Example: =AVERAGE(B1:B20) calculates the average of values in cells B1 to B20.
MAX:
Finds the lowest value in a range of cells.
- Formula: =MIN(range)
- Example: =MIN(D1:D12) finds the lowest value in cells D1 to D12.
COUNT:
Counts the number of cells containing numbers.
- Formula: =COUNT(range)
- Example: =COUNT(E1:E25) counts the number of cells in the range E1 to E25 that contain numerical values.
