{"id":157,"date":"2019-04-02T12:28:31","date_gmt":"2019-04-02T09:28:31","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=157"},"modified":"2019-04-04T16:23:38","modified_gmt":"2019-04-04T13:23:38","slug":"the-counta-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-counta-function\/","title":{"rendered":"The COUNTA function"},"content":{"rendered":"\n

The COUNTA<\/strong> function counts the number of cells in a range, that are not empty. <\/p>\n\n\n\n

It is sometimes being confused with its sibling COUNT<\/a><\/strong> function.<\/p>\n\n\n\n

The difference between them is that the COUNTA<\/strong> function counts cells that contain any type of data, while the COUNT function generally counts only cells containing number values.<\/p>\n\n\n\n

Its syntax is similar to the COUNT function:<\/p>\n\n\n\n


COUNTA(v1, [v2])<\/strong> <\/p> v1<\/strong>, v2, … <\/strong>: They are the cell references or cell ranges within which you want to count numbers.
v2, …<\/strong> : Optional arguments that can be up to a maximum of 255 <\/cite><\/blockquote>\n\n\n\n\n

<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here are some video examples of possible uses of COUNTA: <\/strong><\/p>\n\n\n\n

<\/p>\n\n\n\n

In the cell A1<\/strong> enter a function that counts non blank cells for the cell range A3:A15000<\/strong>.
Also, in the cell C116<\/strong> enter a function that returns the number of cells that contain numbers for the cell range C3:C110<\/strong> and in the cell C117<\/strong> enter another function<\/p>\n\n\n\n

\n