COUNTA Function counting almost everything

Today, we are going to talk about the COUNTA func­tion. This func­tion counts almost every­thing, It counts for­mu­la results (Fig. 1),

num­bers writ­ten as text (Fig. 2), 

dates and time (Fig. 3),

log­i­cal val­ues (Fig. 4),

num­bers (Fig. 5),

and errors (Fig. 6). 

It even counts a sin­gle num­ber or val­ue that we put as an argu­ment to COUNTA func­tion (Fig. 7) 

Let’s write an array with four ele­ments. It does­n’t mat­ter how many columns of rows this array has, but it’s impor­tant how many ele­ments there are. So, we have a range of two cells with num­bers, a sin­gle val­ue and four ele­ments (Fig. 8). 

Since COUNTA func­tion counts every ele­ment, it returns 7 (Fig. 9)

How­ev­er, there is one thing that the COUNTA func­tion does­n’t count. It does­n’t cells that are real­ly emp­ty. Cell A14 is real­ly emp­ty, how­ev­er cell B14 isn’t. It has got a for­mu­la that returns an emp­ty text string. COUNTA func­tion counts an emp­ty text string (Fig. 10).

Even if a for­mu­la returns a val­ue from an emp­ty cell (B15), the COUNTA func­tion will count cell A15 because it has got a for­mu­la (Fig. 11)

The for­mu­la in cell B14 was count­ed by the COUNTA func­tion (Fig. 12)

How­ev­er, if we delete the for­mu­la, the COUNTA func­tion will return 0 because cells A14 and B14 are now real­ly emp­ty (Fig. 13)

Sum­ming up, the COUNTA func­tions counts every­thing except for emp­ty cells. 

https://www.youtube.com/watch?v=kFHAkf9zDBg