+ Reply to Thread
Results 1 to 2 of 2

IF formula to calculate number of times a number appears in a range based on the next cell

  1. #1
    Registered User
    Join Date
    08-20-2012
    Location
    Glasgow
    MS-Off Ver
    Excel 2007
    Posts
    77

    IF formula to calculate number of times a number appears in a range based on the next cell

    Hi,

    In column A I have a list of numbers as below:

    A1. 1
    A2. 2
    A3. 1
    A4. 3
    A5. 4
    A6. 3
    A7. 5
    A8. 5

    In column B I want a formula that looks at the value in Column A, for example cell A1 is the 1 value, and returns the value 2 because there are two number 1s in column A. Similarly, cell A3 will also return the 2 value.

    Many Thanks

    David

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: IF formula to calculate number of times a number appears in a range based on the next

    In B1 use

    =COUNTIF($a$1:$a$8,a1)

    copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. count the number of times a number appears in a specific range
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2013, 11:01 AM
  2. [SOLVED] Want to count the number of times a particular letter appears within a range
    By dwhite30518 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-11-2013, 01:24 PM
  3. Counting the number of times a range of values appears in a table.
    By mikenola in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-19-2010, 12:52 PM
  4. Count how many times a number appears within a range of two numbers
    By Maristar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2009, 10:56 AM
  5. Replies: 0
    Last Post: 08-25-2005, 05:44 AM

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