Hello,

i have given the scenario and expected result from a formula. Can someone let me know if it is feasible and if so how can it be accomplished

Example:

A B C D E F G
Name Cat1 Cat2 Cat2 Cat1 Cat2 Cat1

1 Name1 Y Y N N Y Y

2 Name2 N N Y N Y y

3 Name1 Y Y N Y N Y

Expected Result

G4 = Name1 ( Input value)
G5 = Cat1 ( Input value)
G6 = Formula should help to : Count of Number of Y across ALL columns for Given value in G4 & G5 ( it should count all the Ys appearing in all Columns between B:G but it should count only if the Column Header = Value in G5 (Cat1 in this example) and Name=value in G4 ( Name1 in this example)
Thanks.