Perhaps =SUMPRODUCT(('2015'!$B$2:$B$19=Count!A2)*('2015'!$A$2:$A$19=1)) in B2. Pull down as needed
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.
Perhaps =SUMPRODUCT(('2015'!$B$2:$B$19=Count!A2)*('2015'!$A$2:$A$19=1)) in B2. Pull down as needed
oh my just what I was looking for..thanks a lot!!
thanks a lot and surely it works! but how do I apply name range in between 2 different excel files using the formula?
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.
Bookmarks