Functions
Function COUNTA - INSERT FUNCTION dialog box

Function COUNTA (statistical function) counts the number of cell that are not empty.

Excamples:

 

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

Function COUNTA - INSERT FUNCTION dialog box, steps:

  1. Select the cell for result.
  2. Click the INSERT FUNCTION button .
  3. Select a function COUNTA.
  4. Select the cell(s) - range for calculation;
  5. OK button.
  6. The end (Kraj).

Functions    Index