Help with tweaking formula

  • Thread starter Thread starter Johndb
  • Start date Start date
J

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
 
SMartin,

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

Hope that helps.

Thanks,

John
 
Back
Top