What is the difference between Excel functions COUNT and COUNTA?

When it comes to Microsoft Excel, the COUNT and COUNTA functions are both used to count the number of cells in a range that contain data. However, there is a subtle difference between the two:

The COUNT function counts only the cells that contain numbers in the specified range, while the COUNTA function counts all non-empty cells, regardless of whether they contain numbers, text, errors, or other types of data.

In summary, the key difference between COUNT and COUNTA in Excel is that COUNT counts only numerical values, while COUNTA counts all non-empty cells in a range.