Thanks!
"Domenic" wrote:
Try...
=SUMPRODUCT((I1:I18={"GTB1","LOB1"})*(J1:J18=0))
or
=SUMPRODUCT(--(ISNUMBER(MATCH(I1:I18,{"GTB1","LOB1"},0))),--(J1:J18=0))
Hope this helps!
In article ,
"PhilGTI" wrote:
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.
|