The function COUNT takes an argument that evaluates to numbers or dates and cannot work with values of type String.

 Hi All,

So we try to read on what COUNT, COUNTX, COUNTA and all the other types of COUNT and we go nuts trying to figure out its difference

Finally I was able to understand the difference between COUNT and COUNTA

COUNT - would count int and date type columns only

COUNTA - would count text values. 

So if you encounter the error listed in the header then use COUNTA instead of COUNT

Enjoy coding !!