count across multiple columns with multiple criteria

I'm trying to count values that match a certain criteria as attached. The criteria would be same name, same sales number and same percentage point.
I've tried sumproduct but it is giving me a value of zero.
Any help would be much appreicated.

=SUMPRODUCT(--(A4:T4="Name")*(A4:T14="john")*(A4:T4="sale")*(A4:T14=5)*(A4:T4="percentage")*(A4:T14=5))

Originally Posted by Glenn Kennedy

A giuess, as you didn't tell us what you expect to see!!

=SUMPRODUCT(($A$5:$Q$14=$I$21)*($B$5:$R$14=H23)*($C$5:$S$14=H23))

Thanks for your input. I already tried this formula but doesnt show the correct value. Ive attached a sample excel file for uour viewing. Thanks

the issue in your current SUMPRODUCT is that you're asking if the value in A5 is John, 5 and 5... and they're mutually exclusive, i.e. you need to offset each range for each test (so when A is John, B = 5 etc)

=SUMPRODUCT((A4:Q4="Name")*(A4:Q14="john")*(B4:R4="sale")*(B4:R14=5)*(C4:S4="percentage")*(C4:S14=5))

but, as your field layout repeats, you don't need to do all of that -- i.e. below COUNTIFS will yield same result

=COUNTIFS(A5:Q14,"John",B5:R14,5,C5:S14,5)