How to use COUNT function in Microsoft excel?

About Function:

The Excel COUNT function use to count of cells that contain numbers.

The COUNT function returns the count of numeric values in the list of supplied arguments. Arguments can be individual items, cell references, or ranges up to a total of 255 arguments. All numbers including negative values, percentages, dates, fractions, and time are counted. Empty cells and text values are ignored.

Purpose of Function:

Count the number of cells

Output Value:

The count of cells that contains numeric value

Syntax:

=COUNT(value1, [value2], …)

Arguments:

value1 – an item, cell reference or range.

value2 – [Optional] an item, cell reference or range.

Example 1 - Range:

Function	Output
=COUNT(C7:C14)	returns 5

 In the above example, COUNT function is set up to count the values in the range C7:C14. And the output of the function will return 5 since there are four numeric value in that specified range. Text value and blank cells are ignored by this function.

Example 2 - Constant:

Function	Output
=COUNT(1,2,3,”world”)	returns 3

In the above example, out of four value, three are numeric and one is text. Therefore, the output of this function will return 3.

Other Relevant Posts:

• How to use SUM function in Microsoft excel?
• How to use IF function in Microsoft excel?
• Simple Project Management Dashboard using Microsoft excel
• Calculator using VBA in Microsoft Excel