Excel Guide
COUNT, COUNTIF & AVERAGE, Explained
Excel has three different "COUNT" functions that all sound similar and do genuinely different things. Mixing them up is one of the most common beginner mistakes — here's how to tell them apart.
COUNT vs. COUNTA
COUNT counts only cells containing numbers. COUNTA counts any cell that isn't empty — numbers, text, dates, all of it.
If your range mixes names and scores, COUNT tells you how many scores were entered; COUNTA tells you how many rows have anything in them at all. Using COUNT when you meant COUNTA (or vice versa) is a very easy off-by-a-few-rows bug to introduce.
COUNTIF: counting with a condition
COUNTIF counts cells that match a condition — a specific value, or a comparison like "greater than":
Need more than one condition? COUNTIFS takes multiple range/criteria pairs — every condition has to match for a row to be counted:
AVERAGE and AVERAGEIF
AVERAGE does what it says — the mean of a range, ignoring text and blanks. AVERAGEIF adds a condition, following the same pattern as COUNTIF and SUMIF (a check range, a criteria, and optionally a separate range to average):
#DIV/0! error, since it's dividing by zero rows. AVERAGEIF does the same if nothing matches the condition — worth wrapping in IFERROR if the range might legitimately be empty.Try it yourself
Practice COUNT, COUNTIF, AVERAGE and more with real interactive exercises and instant feedback.
Start practicing counting formulas →