Sumproduct Questions

[MESTRELLA29]

=(SUMPRODUCT((A!$D$2:$D$10000="B")*(A!$F$2:$F$10000=INDIRECT(A4))*(LEFT(A!$G$2:$G$10000,4)="3907")*(A!$J$2:$J$10000)))

is it posible to put Or condition to this formula,

I need to pick Up "b" ,"c", "s" From My data base.
(A!$D$2:$D$10000="B")+(A!$D$2:$D$10000="C")+(A!$D$2:$D$10000="S")

Thanks for your help

 

[Tom Ogilvy]

=SUMPRODUCT((((A!$D$2:$D$10000="B")+(A!$D$2:$D$10000="C")+(A!$D$2:$D$10000="
S"))>0)*(A!$F$2:$F$10000=INDIRECT(A4))*(LEFT(A!$G$2:$G$10000,4)="3907")*(A!$
J$2:$J$10000))

 

[MESTRELLA29]

How do you all this StuFF.

Thanks

=SUMPRODUCT((((A!$D$2:$D$10000="B")+(A!$D$2:$D$10000="C")+(A!$D$2:$D$10000="
S"))>0)*(A!$F$2:$F$10000=INDIRECT(A4))*(LEFT(A!$G$2:$G$10000,4)="3907")*(A!$
J$2:$J$10000))

 

[Tom Ogilvy]

You did it. You had all the parts (the plus sign works as an OR operator) -
you just needed to put them together. In fact, you don't need the >0 part I
put in - I didn't look closely enough to see it is B, C or S in the same
column - mutually exclusive conditions -- so the sum would never be greater
than 1). Nonetheless, it should work as I posted it or you could remove the

 

[MESTRELLA29]

Thanks a Lot Again

You did it. You had all the parts (the plus sign works as an OR operator) -
you just needed to put them together. In fact, you don't need the >0 part I
put in - I didn't look closely enough to see it is B, C or S in the same
column - mutually exclusive conditions -- so the sum would never be greater
than 1). Nonetheless, it should work as I posted it or you could remove the