Excel 2003 Help with SUMPRODUCT & finding unique values with conditions

[NewbieDoo]

Hi, this is my first post so I hope someone can help.

My dataset:

[TABLE="width: 144"]
<TBODY>[TR]
[TD="width: 64, bgcolor: transparent"]Fruit
[/TD]
[TD="width: 64, bgcolor: transparent"]Item Set
[/TD]
[TD="width: 64, bgcolor: transparent"]Available
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Banana
[/TD]
[TD="bgcolor: transparent"]A1
[/TD]
[TD="bgcolor: transparent"]Y
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Apple
[/TD]
[TD="bgcolor: transparent"]A2
[/TD]
[TD="bgcolor: transparent"]N
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Banana
[/TD]
[TD="bgcolor: transparent"]A2
[/TD]
[TD="bgcolor: transparent"]N
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Kiwi
[/TD]
[TD="bgcolor: transparent"]A2
[/TD]
[TD="bgcolor: transparent"]N
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Apple
[/TD]
[TD="bgcolor: transparent"]A1
[/TD]
[TD="bgcolor: transparent"]Y
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Peach
[/TD]
[TD="bgcolor: transparent"]B1
[/TD]
[TD="bgcolor: transparent"]Y
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Apple
[/TD]
[TD="bgcolor: transparent"]A1
[/TD]
[TD="bgcolor: transparent"]Y
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Apple
[/TD]
[TD="bgcolor: transparent"]A1
[/TD]
[TD="bgcolor: transparent"]Y
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Apple
[/TD]
[TD="bgcolor: transparent"]A0
[/TD]
[TD="bgcolor: transparent"]Y
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Banana
[/TD]
[TD="bgcolor: transparent"]C2
[/TD]
[TD="bgcolor: transparent"]N
[/TD]
[/TR]
</TBODY>[/TABLE]


I am using Excel 2003 formula:

=(SUMPRODUCT((B24:B100<>"")/COUNTIF(B24:B100,B24:B100&"")))

to give me the number of available sets = 5 (A0, A1, A2, B1 & C2)

and

=SUMPRODUCT(--(LEFT(A24:A100,5)="Apple"),--(LEFT(B24:B100,1)="A"),--ISNUMBER(FIND("Y",C24:C100)))

to give me the number of sets containing "Apple", beginning with "A" and available "Y" = 4

The output I actually need is 2, that is the number of "A" sets that are available "Y" and contain Apples = 2 (A0 & A1)

Does anyone know how to do this? Any help would be appreciated