Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello all. I am having a problem witha sum product formula. I have Mulitple
Conditions and have to use the + sign to include all of them. Hereis an example of my formula: =Sumproduct((Range1=200601)*((Range2<1000)+(Range 2<2534)+(Range2<7486))*(Range3)*(Range4)) This formula returns a value but it is much higher than it should be. I have read places about possbily using an array inside myformula to help take care of this but I have not had any luck yet. Any help you can provide would be greatly appreciated. Thanks, Chad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex Excel Problem involving Step Costs | Excel Worksheet Functions | |||
Sum Product Question | Excel Worksheet Functions | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Which Function(s) do I use? | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions |