Question: what is the difference between count and counta?
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. Think of it as “Count Anything”.