how to count non blank cells with condition?
situation:
Column A (Name)
Column B (Division - man,woman,young man, young woman)
Column C (quantity of subscription - number)
*some of them may subscribe more than 1 magazine
just wanna find out how many of young woman did subscribe the magazine (not the quantity of magazine)
so what formula i can use? anyone can help me please~
situation:
Column A (Name)
Column B (Division - man,woman,young man, young woman)
Column C (quantity of subscription - number)
*some of them may subscribe more than 1 magazine
just wanna find out how many of young woman did subscribe the magazine (not the quantity of magazine)
so what formula i can use? anyone can help me please~