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