Preparing your learning space...
17% through AI Formula Generator tutorials
Summing and counting is where almost every Excel workflow starts. SUM adds numbers, COUNT tells you how many cells hold numbers, and their conditional versions add rules to both. Once you master these, the rest of the formula family clicks into place.
A formula is an instruction you type in a cell, always starting with an equals sign =. It can reference other cells, call functions, and calculate a result that updates when the source data changes. You don't compute anything yourself — you describe the calculation and Excel does it.
=A2 + A3
This adds the contents of A2 and A3. Change either cell and the result updates automatically. That live-update behavior is the whole point of formulas.
SUM adds up all the numbers you give it. It's the most used function in Excel, and it replaces the old habit of typing =A2+A3+A4... by hand.
Syntax: =SUM(number1, [number2], ...)
=SUM(A2:A6) =SUM(B2:B6, D2:D6) =SUM(A2:A6) / 12
The first line sums every number from A2 to A6. The second adds two separate ranges in one go. The third shows SUM combined with other math — here, an annual total divided by 12.
Note: SUM quietly ignores text and empty cells inside a range, so SUM(A2:A6) never throws an error even if someone typed a word into A4.
Best practice: Prefer ranges (A2:A6) over listing cells (A2,A3,A4,A5,A6). Ranges stay correct when you add rows in between.
COUNT counts how many cells in a range contain a number. If your goal is "how many rows actually have data," this is the function — but only when that data is numeric.
Syntax: =COUNT(value1, [value2], ...)
=COUNT(A2:A10)
The result is a plain number: how many cells in A2:A10 hold numbers. Blanks and text cells are skipped entirely. A column of names would return 0, which surprises beginners — see COUNTA below for that case.
Common mistake: COUNT ignores text. If you count a list of product names with COUNT, you get 0, not the number of products. Use COUNTA when the values are text.
COUNTA counts every cell that isn't empty — numbers, text, dates, anything. COUNTBLANK is the opposite: it counts only the empty cells.
=COUNTA(A2:A10) =COUNTBLANK(A2:A10)
COUNTA(A2:A10) tells you how many cells have something in them. COUNTBLANK(A2:A10) tells you how many are waiting to be filled. The two should add up to the total range size — a handy sanity check.
These are the conditional versions. COUNTIF counts cells that meet one rule; SUMIF adds the numbers that meet one rule. They're the natural step up when "count everything" isn't specific enough.
Syntax: =COUNTIF(range, criteria) — =SUMIF(range, criteria, [sum_range])
=COUNTIF(B2:B10, ">100") =SUMIF(B2:B10, ">100") =SUMIF(C2:C10, "West", D2:D10)
The first line counts how many sales were above 100. The second adds up only those sales. The third checks the region in column C and sums the matching amounts from column D — the criteria and the values being summed live in different columns.
"West"), and number comparisons too (">100"). A bare 100 would only match cells exactly equal to 100.Save your progress and earn XP for completing tutorials.
Keep learning
Technology
Excel with AI
Lesson group
AI Formula Generator
Progress
17% complete