SUM
SUM adds every number in the range you give it.
Read the SUM guide →Free learning guides
Excel formulas, explained simply.
Start with one useful idea. See an example, understand the common mistakes, then try it yourself.
AVERAGE
AVERAGE adds the values and divides by how many there are.
Read the AVERAGE guide →COUNT
COUNT includes only numeric cells. It skips text and blanks.
Read the COUNT guide →COUNTIF
COUNTIF counts only the cells that meet the condition.
Read the COUNTIF guide →IF
IF tests a condition and returns the corresponding result.
Read the IF guide →XLOOKUP
XLOOKUP finds a match and returns the value from the same row in the return range.
Read the XLOOKUP guide →