Thread: Sumproduct ??
View Single Post
  #1   Report Post  
PhilGTI
 
Posts: n/a
Default 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.