Count Vs counta In Excel



COUNT VS COUNTA In Excel

Count : count your excel sheet cell number/text data there is two way count cell number data in excel one is count formula and second is counta formula uses in excel sheet.

See example of count and counta and try it yourself in excel 

First we use count for number data it only count number cell; not to text cell

Count example with formula 



Microsoft Excel

Formula Uses in for count number Cell
=count(A1:A11)  select cell according to your excel sheet


See Result of count in below image we select all data included with text but only get result of number  


Microsoft Excel


Counta : counta is uses for count all cell data included with text and number if you want count all cell data then you should use counta in excel...


Microsoft Excel

Formula Uses in for count number Cell with text 
=counta(A1:A11)  select cell according to your excel sheet


See Result of counta in below image we select all data included with text and get all cell count number


Microsoft Excel






Visit More