Forum Discussion
Problems with using COUNTA with multiple choice cells from a Microsoft List
Good afternoon. I am having some issues using COUNTA when counting populated column cells in data view that contains text from a Microsoft List that uses a choice selection (Yes, No, or left blank) ...
johnt75
Super User
Super UserFrom the Microsoft docs
Like the COUNTA function, the COUNTAX function counts cells containing any type of information, including other expressions. For example, if the column contains an expression that evaluates to an empty string, the COUNTAX function treats that result as non-blank. Usually the COUNTAX function does not count empty cells but in this case the cell contains a formula, so it is counted.It could be that the cells contain some info rather than actually being blank.
It might be worth checking if the cells return true for ISBLANK().
Johnt75,
Thank you. Using the ISBLANK() function verified that the cells are not truly blank when they appear to be. The results came back False for the ones that were in question. Is there a function that would work to count only the cells that visually have content in them? I have not been able to discover one as of yet. Thank you for your help.
- johnt75
You could look into using Power Query to transform those cells into actual blanks. You could try using the trim function and then converting empty strings to null maybe.