Sumproduct ??
 

Ive 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 didnt work, it returned #value!
Thanks for your help.

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.

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:

Ive 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 didnt work, it returned #value!
Thanks for your help.

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.