Excel offers numerous approaches for counting cells including utilizing the Find function or a filter. But with features, you can count exactly what you need. From filled cells to spaces, from numbers to message, right here’s just how to count cells in Excel.
Count Cells With Numbers: The COUNT FunctionCount Blank Cells: The COUNTBLANK FunctionCount Nonblank Cells: The COUNTA FunctionCount Cells With Specific Criteria: The COUNTIF Function
Count Cells With Numbers: The COUNT Function
If you intend to count the number of cells that contain just numbers, you can utilize the COUNT function. The phrase structure for the formula is: COUNT(value1, value2, …) where value1 is called for as well as value2 is optional.
You’ll use value1 for your cell referrals, the range of cells you wish to count within. You can use value2 (as well as subsequent debates) to include a specific number or one more cell variety if you like. Let’s look at a number of instances.
To count the variety of cells in the array A1 via D7 which contains numbers, you would kind the adhering to and also struck Enter:
You then obtain the result in the cell having the formula.
To count the number of cells in 2 separate ranges B2 via B7 as well as D2 via D7 which contain numbers, you would certainly kind the complying with and press Enter:
Now you’ll see the overall matter of numbers for both of those cell arrays.
Count Blank Cells: The COUNTBLANK Function
Maybe what you want to discover is the number of blank cells you have in a particular range. You’ll utilize a variant of the COUNT feature, COUNTBLANK. The phrase structure for the formula is: COUNTBLANK(value1) where value1 contains the cell recommendations and is required.
To count the variety of blank cells in the range A2 with C11, you would type the following and press Enter:
You’ll then see the lead to the cell where you got in the formula.
For additional COUNTBLANK examples and makes use of, check out our tutorial for counting blank or vacant cells in Excel.
Count Nonblank Cells: The COUNTA Function
Perhaps you would certainly like to do the precise opposite of checking cells that are blank and rather count cells which contain information. In this situation, you would use the COUNTA function. The phrase structure is COUNTA(value1, value2, …) where value1 is called for as well as value2 is optional.
Just like the COUNT feature above, value1 is for your cell referrals and value2 is for added varieties you want to consist of.
To count the number of nonblank cells in the variety A2 via C11, you would certainly type the following as well as struck Enter:
As you can see, the COUNTA function counts cells including any kind of kind of information. This consists of numbers, message, mistakes, and also empty text or strings. As an example, the error in cell C7 is counted.
If a mistake is providing you problem, it’s very easy to conceal mistake worths in your spread sheets.
Count Cells With Specific Criteria: The COUNTIF Function
If you wish to count the number of cells having details information, you would certainly utilize the COUNTIF feature. The phrase structure for the formula is COUNTIF(value1, standards) where both value1 and standards are called for.
Like the other functions below, value1 consists of the cell referrals for the variety. Requirements is the product you intend to look for and can be a cell referral, word, number, or wildcard. Allow’s look at a couple of standard instances.
To count the variety of cells in the range C2 via C6 that contain the word “socks,” you would certainly kind the following and also press Enter:
Notice that if your standard is a word, you need to border it in dual quotes.
To count the number of cells in the variety B2 through C6 which contain what’s in cell B2, you would kind the following and press Enter:
In this case, you would certainly not position the B2 cell reference in double quotes.
For extra COUNTIF examples as well as uses, take a look at our how-to for utilizing COUNTIF in Excel.
Counting cells in Microsoft Excel is straightforward once you understand these standard features and exactly how to utilize them. But if you’re interested in something like highlighting blanks or errors instead of just counting them, we have you covered!