You are viewing a single comment's thread from:

RE: Tips for Analyzing Categorical Data in Excel

in #excel6 years ago

Hi @paulag and @theexcelclub - I have a tip I can share with Jeff.
COUNTA will allow you to count text items whereas COUNT is used for numbers and dates. So If I was summarizing categorical data I would use COUNTA

Sort:  

Hi @dernan, yes the COUNTA function in excel is great when working with categorical data.