How To Use Excel COUNT Function – A Quick Guide

Having given a set of data which include different data types, If I ask you to find the total count of numbers in it.

How will you do that?

For sure I will pick COUNT function…!!!

Let us see how to use it in detail…

1. What is COUNT Function?
2. What is the Syntax?
3. How to use it with an example?


1. What is COUNT Function?

The COUNT function can be used to count the number of cells that contain Numerics and counts the numbers within the list of arguments.


2. What is the Syntax?

 

=COUNT(value1, [value2], …)

 

  • value1   = Can be an item, cell reference, or range within which you want to count numbers.
  • value2 =  Optional and can be up to 255 additional items, cell references, or ranges within which you want to count numbers.

Note :

  • Dates, Logical values and text representation of numbers .i.e a number enclosed in quotation marks, such as “1” are counted when given directly as arguments.
  • Empty cells, logical values, text, or error values in the array or reference are not counted.

3. How to use it with an example?

Suppose we have a list of items, which may include different types of elements in it.

Here is how we can count the number of numerics in the given list.

@Checkout the example
excel count function

Hope it has helped you…

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply