Forum Discussion
Solved
Problem with COUNT function
Hello All, Having a problem trying to figure this out, and it sure seems like it should be easy... I'd like to calculate the % of discount codes redeemed. My table has CodeID (created each ti...
GilesWalker Your solution will work if the CodeID is a numeric value but it can be a text value and a68tbird wants to count text values in the column.
a68tbird Count function only works with numeric and date values in the column. See here
In case you want to count text values you need to use COUNTA() instead of COUNT()
GilesWalker Your solution will work if the CodeID is a numeric value but it can be a text value and a68tbird wants to count text values in the column.
a68tbird Count function only works with numeric and date values in the column. See here
In case you want to count text values you need to use COUNTA() instead of COUNT()
Thanks very much! COUNTA was what I needed. Simple fix.