Results 1 to 5 of 5

Thread: Count How many times an item appears in relation to a value from another cell

  1. #1

    Count How many times an item appears in relation to a value from another cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have 2 worksheets, what I want to achieve is to count how many times an item in column B appears if column A has a value of "1" on it. Worksheet 2 will show the result.


    Attached Files Attached Files

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Perhaps =SUMPRODUCT(('2015'!$B$2:$B$19=Count!A2)*('2015'!$A$2:$A$19=1)) in B2. Pull down as needed

  3. #3
    oh my just what I was looking for..thanks a lot!!

  4. #4
    thanks a lot and surely it works! but how do I apply name range in between 2 different excel files using the formula?

  5. #5
    I added a new criteria to the equation, like if I add in column C "months" and it should only count with specific months (January and February) along with criteria of "1" in column A.

Posting Permissions

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