+ Reply to Thread
Results 1 to 2 of 2

How to count the amount of a number in a column

  1. #1
    Registered User
    Join Date
    01-02-2005
    Posts
    1

    How to count the amount of a number in a column

    Hi,

    I'm wondering how I can make excel count how much of a certain number there is in a column. For example.

    Column 1
    3
    2
    1
    1
    2

    How can I make excel figure out that there are 2 "ones" in column one and have excel return the number 2 in a certain cell?

  2. #2
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    Cell A1 is where you type the number whose occurrences you want to count. The list of mixed numbers are put into cells B1 to B10. Put this formula into cell B11, "=COUNTIF(B1:B10,A1)" (without the quotes). B11 is the cell in which your answer will appear. Obviously, you can re-arrange the cells to suit once you understand how the formula works.

+ 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.6.0 RC 1