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
|