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