abc MICROSOFT EXCEL 2010 - Functions
Counting cells with content function (COUNTA)

Function COUNTA (statistic Function) counts cells which aren't empty in the selected range.

Picture 1. Function COUNTA - Counting cells with content /FUNCTION COUNTA/
 

examples:

  

 

A

B

C

D

E

F

G

1

          

COUNT

COUNTA

2

21

2

      

2

2

3

6

4

1

2

99

5

5

4

1

3

 a  

21

3

4

5

 a b c

3

5

2

5

6

 6A b3

3

6

 1a

2

5

 

A

B

C

D

E

1

 1 2 3 znanje.org  

 

Function COUNTA

Ćelije

Rezultat

=COUNTA(A1:C1)

A1,B1,C1

3

=COUNTA(A1:D1)

A1,B1,C1,D1

4

=COUNTA(A1:E1)

A1,B1,C1,D1,E1

4

=COUNTA(A1:C1,20)

A1,B1,C1 i 20

4

=COUNTA(A1,C1)

A1,C1

2

=COUNTA(A1,D1)

A1,D1

2

=COUNTA(A1,E1)

A1,E1

1

Picture 2. Function COUNTA - Counting cells with content /FUNCTION COUNTA/

Picture 3. Function COUNTA - Counting cells with content /FUNCTION COUNTA/

 

Counting cells with content function (COUNTA), steps:

  1. Select the cells;
  2. Press the button to add a function /INSERT FUNCTION/ .
  3. Select the statistic functions;
  4. selectCOUNTA.
  5. Define the area.
  6. The end (Kraj).

Functions    Index