+ Reply to Thread
Results 1 to 3 of 3

Thread: Autocount the number of each entry in a column

  1. #1
    Registered User
    Join Date
    01-17-2010
    Location
    Oregon
    MS-Off Ver
    Excel 2010
    Posts
    2

    Autocount the number of each entry in a column

    I feel like I should be able to do this with the sum feature, but I haven't been able to figure it out.

    I have columns with responses coded in numbers, 1-5. I want to be able to automatically output for each column a results field or field that will tell me how many 1s, how many 2s, etc. Is there an easy way to do this?

    thanks in advance for any help,
    tvanhorne

  2. #2
    Forum Guru
    Join Date
    10-28-2008
    Location
    Not here anymore
    MS-Off Ver
    irrelevant
    Posts
    10,151

    Re: Need to autocount the number of each entry in a column

    Hi,

    try

    =countif(A1:A100,1)

  3. #3
    Registered User
    Join Date
    01-17-2010
    Location
    Oregon
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need to autocount the number of each entry in a column

    Thank you! That's what I was trying to figure out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0