Microsoft Excel owes much of its popularity to its helpfulness with HOW questions. How much...? How long...? How big...?
Perhaps the most common of these is How many...? This week we'll be looking at the various formulas that help us answer this question. Let's start with the most basic formula in this family: the COUNT function.
The COUNT function takes a range (or multiple ranges!) of cells and returns the count of cells with number values in the group specified.
As you'll notice below, this particular COUNT formula does not take into account cells that are blank, have errors, or contain text. Only numerical values get counted.