| 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 |
| 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) | |||
![MESTRELLA29[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
