Hi

I require to count unique entries in excel albeit on satisfying two criterias. My data is organised like this:

Col A Col B

A Jun

A July

A Aug

B Jun

B Jul

B Jul

C Jun

C Aug

Now I want a unique count of entries in column A that fall BOTH in June AND July. So in the above case value A comes in June and July therefore the count for A should be 1. Similarly B also falls in Jun and July so the count should be 1 for B as well. However C comes in June but not in July and hence the count for C should be 0. So the final answer should be 2 achieved as (1+1+0). I would like to extend this formulae to include more criterias. Request someone to kindly help.