How to use Statistical Functions to count values

Hi friends today we discuss most important count and related statistical functions in MS Excel which is mostly used the different persons in different industries. These statistical functions are used to count all given number within given range of cells or an array. Here I try to describe few important statistical functions to count values like count, counta, countblank, countif and countifs function.

Most Important Statistical Functions to count values:

Here are few important functions which belong to easily count number of values during doing daily routine official job. These Statistical functions are widely used by most of the persons.

Statistical Functions

1. Count( ):
It is one of the most important statistical functions which are used to for those numbers which you want to count from given range of cells in any worksheet.

Formula: COUNT(value_1,value_2,…)

Note: You can insert 1-255 arguments as a Value1, value2, and many more that contain different kind of figures, count function only count number from given range of cells.

Example:
Statistical-Functions-to-count-values

If you have a worksheet data and now you want to count numeric values from the given range of cells then you can apply following given formula in active sheet =COUNT(A2:B8) press enter key excel shows the result 6.

Must Read: 3 Ways to quickly find duplicate values in Excel

2. Counta( ):
This is another important statistical function which can be used to easily count non-empty cells of any kind of format from given range of cell or an array.

Formula: COUNTA(value1,value2,…)

Note: You can insert 1-255 arguments as a Value1, value2, and many more that contain different kind of data.Value1, value2, …   are 1 to 255 arguments representing the values you want to count.Example: =COUNTA(A2:B8) now press enter key excel shows the result 13.

3. Countblank( ):
This kind of statistical function used to easily count all empty cells from given range of cells or an array. This function also counts any empty text values but not count those cells which have zero values from the range of given cells.

Formula: COUNTBLANK(range)

Range: It is a range of cells or an array which is used to count all empty cells.

Example: =COUNTBLANK(B2:B8), after applying this formula when you press enter key excel displays 1 as a result.You can also count all blank columns in any blank worksheet by applying this given formula:=countblank(1:1), when you press enter key you get total number of columns 16384 in active sheet.

4. Countif( ):
This function is used to count those cells that meet multiple criteria from given cells values in any worksheet.

Formula: COUNTIFS(range, criteria)

Criteria_range1: It is the range of continuous cells which you want to evaluated for the specific condition.
Criteria1: It is the condition in the form of any number, expression or text value that define which cells to be counted.

=COUNTIF(A2:B8,”a”)

After applying this formula in any specified cell where you want to view the result when you press enter key it will shows you 2 as a result.

5. Countifs( ):
This function is used to count the number of cells within a range or cells or any array that match in the multiple condition.

Must Read: How to use Vlookup and Hlookup Functions in Excel

Formula: COUNTIFS(range1, criteria1,range2, criteria2…)

Range1, range2, …  : You can give up to  1 to 127 ranges  which include any number, name, array or reference that contain any kind of number, but blank and text values are ignored. Criteria1, criteria2, …   You can give up to 1 to 127 conditions in which you can set any number, expression, cell address, or any text value that define which cells will be counted.Example: =COUNTIFS(A2:A8,”a”) after applying this formula when you press enter you get the result 2.

I hope this post increase your knowledge give your important suggestions in the comment box and also share your knowledge with others. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *