Sumproduct Questions
 

=(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

Sumproduct Questions
 

=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

Sumproduct Questions
 

How do you all this StuFF.

Thanks

"Tom Ogilvy" wrote:

=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

Sumproduct Questions
 

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
0 part.

--
Regards,
Tom Ogilvy

"MESTRELLA29" wrote in message
...
How do you all this StuFF.

Thanks

"Tom Ogilvy" wrote:


=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

Sumproduct Questions
 

Thanks a Lot Again

"Tom Ogilvy" wrote:

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
0 part.

--
Regards,
Tom Ogilvy

"MESTRELLA29" wrote in message
...
How do you all this StuFF.

Thanks

"Tom Ogilvy" wrote:


=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