This post will guide you how to use Excel COUNT function with syntax and examples in Microsoft excel.

Table of Contents

## Description

The Excel COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. It returns a numeric value that indicate the number of cells that contain numbers in a range.

The COUNT function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.

The COUNT function is available in Excel 2016, excel 2013, excel 2010, excel 2007, excel 2003, excel XP, excel 2000, excel 2011 for Mac.

## Syntax

The syntax of the COUNT function is as below:

= COUNT(value1, [value2],…)

Where the COUNT function arguments are:

**value1**-This is a required argument. The first item, cell reference, or range within which you want to count numbers.**Value2**– This is an optional argument. You can enter up to 255 value arguments.

**Note: **

- Arguments that are numbers, dates, or a text representation of numbers (for example, a number enclosed in quotation marks, such as “1”) are counted.
- If the argument is an array or reference, only numbers in that array are counted. Empty cells, logical values, text, or error values in the array or reference are not counted.
- You can use the COUNTA function to count logical values, text, error values.
- You can use the COUNTIF function to count only numbers that meet certain criteria.
- You can provide up to 255 number arguments in excel 2007 or later. If you are using excel 2003, you can only provide up to 30 number arguments.

## Excel COUNT Function Examples

The below examples will show you how to use Excel COUNT Function to count the number of cells that contain numbers in a range.

#1 To count the number of cells in the range B1:B4, just using the following excel formula:

=COUNT(B1:B4)

## Leave a Reply

You must be logged in to post a comment.