[PDF]Count Function In Excel

Imparting knowledge

Gyan Sangrah

Count function in excel

In this article, we will discuss count function in excel.

Purpose

Purpose of count function is to count the number of cells. It is important to note that count
function ignores those cells that do not contain any value.

Count function also ignores the non-numeric values. It means that if there are 3 cells with 2
numeric values and one alphabet then count will return 2.

Syntax

=Count( iteml, item2....)

Or

=Count(Range of cells)



Example



ABC

-Tmint/I T 3 X «A N 3 3


A

5


-LOUnt(l,Z,J,4, A ,1.5

A B C D E F


A B C D E F

1

1 2 3 4 A 2.5|

| ^ ^ 2

ll_2 3 4 A 2.5

2

3

=Count(Al:Fl

3

5


4