Counting visible cells with multiple criteria

[serrulate]

Hello, I am trying to count rows in a filtered table based on criteria in two separate columns
for instance i am trying to count the number of times that both Apple and Monday are visible.

the following works well for counting number of times Apple appears is there a way to add in criteria about a Day also?
=SUMPRODUCT(SUBTOTAL(103,OFFSET(Table2[Fruit],ROW(Table2[Fruit])-MIN(ROW(Table2[Fruit])),,1)),ISNUMBER(SEARCH("*"&H2&"*",Table2[Fruit]))+0)

Fruit	Day
Apple	Monday Tuesday
Pear Apple	Tuesday Thursday
Peach	Saturday
Peach Apple	Thursday Monday
Pear Apple	Tuesday
Strawberry	Monday

 

[Fluff]

How about

=SUMPRODUCT((SUBTOTAL(103,OFFSET(Table2[Fruit],ROW(Table2[Fruit])-MIN(ROW(Table2[Fruit])),,1)))*(ISNUMBER(SEARCH("*"&H2&"*",Table2[Fruit])))*(ISNUMBER(SEARCH("*"&I2&"*",Table2[Day]))))

 

[serrulate]

Brilliant!!!! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.