How Many? Using the COUNT Formula in Excel

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.

Do you need assistance with COUNT or other features of Excel?  Contact us today via live chat, email, or phone and we'll get your issue solved in minutes.  We can also do that Excel project for you if you like... let us know!