=SUMPRODUCT((((A!$D$2:$D$10000="B")+(A!$D$2:$D$100 00="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))

--
Regards,
Tom Ogilvy


"MESTRELLA29" wrote in message
...

=(SUMPRODUCT((A!$D$2:$D$10000="B")*(A!$F$2:$F$1000 0=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