Help with tweaking formula

[Johndb]

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:N3>G3 with no
reference to B3 at all, such as:
=SUMPRODUCT(--(ISNUMBER(H3:N3)),--(H3:N3>G3))


Thanks in advance,

John

 

[Johndb]

SMartin,

H3:N3 can be Numbers, Text, or Blanks. These formula variations are being
used for conditional formatting.

Hope that helps.

Thanks,

John

 

[T. Valko]

http://groups.google.com/group/micr.../browse_thread/thread/bd4d68b0bf6069f8?hl=en#