Community,

Using the base of (which works):

=SUMPRODUCT(--(ISNUMBER(H3:N3)),--(H3:N3=G3))*(B3="S")


How would I write:

=SUMPRODUCT(--(ISNUMBER(H3:N3)),--(H3:N3=G3))*(B3="S")
H3:N3="N" OR "L"
with no reference to B3 at all, such as:
=SUMPRODUCT(--(ISNUMBER(H3:N3)),--(H3:N3="N" or "L"))


=SUMPRODUCT(--(ISNUMBER(H3:N3)),--(H3:N3=G3))*(B3="S")
H3:N3G3 with no
reference to B3 at all, such as:
=SUMPRODUCT(--(ISNUMBER(H3:N3)),--(H3:N3G3))


Thanks in advance,

John