Forum Discussion

robs67stang's avatar
robs67stang
Frequent Visitor
3 years ago

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) ...
COUNTA
robs67stang's avatar
robs67stang
Frequent Visitor
3 years ago

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's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

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.