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

[kewl25]

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.

[Pecoflyer]

Perhaps =SUMPRODUCT(('2015'!$B$2:$B$19=Count!A2)*('2015'!$A$2:$A$19=1)) in B2. Pull down as needed

[kewl25]

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

[kewl25]

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

[kewl25]

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.