How to get a count of unique values based on 2 criteria

[henryg]

I have a list of, say, products with duplicate values allowed in Column A and various numeric values in Column B (eg sales volumes or sales values) including zero. I want a count of the unique items in Column A that have a zero in Column B.

I'm convinced there should be a (simple?) solution, but can't seem to find one.

 

[Fluff]

Glad you sorted it & thanks or the feedback.

 

[Rahul1987]

I have a list of, say, products with duplicate values allowed in Column A and various numeric values in Column B (eg sales volumes or sales values) including zero. I want a count of the unique items in Column A that have a zero in Column B.

I'm convinced there should be a (simple?) solution, but can't seem to find one.

E3 =INDEX($A$2:$A$9,SMALL(IF(B2:B9=0,ROW($A$2:$A$9)-ROW($A$2)+1),ROWS(E$3:E3)))

 

[Fluff]

@Rahul1987
Not sure if you realise but this thread is almost a year old. Also your formula is not counting the number of unique values which is what was asked for.

 

[Rahul1987]

@Fluff
G11 -=SUM(IF(FREQUENCY(IF(B2:B9=0,MATCH(A2:A9,A2:A9,0)),ROW(B2:B9)-ROW(B2)+1),1))

I thought it was asked to extract data...
thanks for your concern , however I am just trying to improve my skills by reading various threads so that it will help me a lot. I am just looking at them now coz I am a new here.