Try
=SUMPRODUCT(--(I1:I18={"GTB1","LOB1"})*--(J1:J18=0))
"PhilGTI" wrote in message
...
I've used this formula successfully
=SUMPRODUCT(--(I1:I18="GTB1"),--(J1:J18=0))
What I would like to do is look for "GTB1" and "LOB1" in column I
I tried
=SUMPRODUCT(--(I1:I18={"GTB1","LOB1"}),--(J1:J18=0))
But it didn't work, it returned #value!
Thanks for your help.
|