Question: what is the difference between count and counta function?
Answer: There are two very similar functions in Excel: COUNT() and COUNTA(). The difference between them is that COUNT only counts cells containing numbers but COUNTA counts all cells that aren't empty.