You are viewing a single comment's thread from:

RE: Tips for Analyzing Categorical Data in Excel

in #excel • 5 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

5 years ago in #excel by
$0.34
  • Past Payouts $0.34, 0.00 TRX
  • - Author $0.26, 0.00 TRX
  • - Curators $0.08, 0.00 TRX
9 votes
Reply 1
Sort:  
  • Trending
    • [-]
     5 years ago 

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

    $0.00
      Reply

      Coin Marketplace

      STEEM 0.20
      TRX 0.14
      JST 0.029
      BTC 68011.48
      ETH 3275.77
      USDT 1.00
      SBD 2.64