Good afternoon - I have the spreadsheet bleow (it's also attached for better layout), and what I want it to get is the total count of non-blank cell from the answer(column B) and only count the answer once for those users that are listed multiple times (columnA).So my total count fro ColumnB should be 18. Please let me know how can I accomplish this.
Thank you in advance!
User Answer
JOSE Yes
MARIA No - Other Reason
MARY No - Other Reason
SHERYL K No - Other Reason
VIGGO J No - Other Reason
IGNACIO No - Other Reason
ISAAC No - Other Reason
LAURA Yes
GUADA No - Other Reason
MERIC No - Other Reason
JUAN No - Other Reason
OLGA No - Other Reason
ARTHUR Yes
CARLA Yes
JOAN No - Other Reason
LILLIE Yes
LILLIE Yes
DOROTHY No - Other Reason
JOHN C
PABLO No - Other Reason
PABLO No - Other Reason
PABLO No - Other Reason
Bookmarks