Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct question and why cant I find my previous questions? | Excel Discussion (Misc queries) | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
Two questions-SUMPRODUCT & IF something | Excel Discussion (Misc queries) |