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)
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 |