Home |
Search |
Today's Posts |
#1
|
|||
|
|||
streamline SUMPRODUCT
I have 3 sumproducts that I am adding together and I would like to
combine them to one formula. Any suggestions? Here are the current formulae: SUMPRODUCT(--(VALUE(RIGHT(PosDeptNum,2))=$A7),--(PosStart<=G$6),--(PosEnd=H$6),PosHrs/40) SUMPRODUCT(--(VALUE(RIGHT(PosDeptNum,2))=$A7),--(PosEnd=G$6),--(PosEnd<H$6),PosHrs/40*(PosEnd-G$6)/(H$6-G$6-1)) SUMPRODUCT(--(VALUE(RIGHT(PosDeptNum,2))=$A7),--(PosStartG$6),--(PosStart<H$6),PosHrs/40*(H$6-PosStart)/(H$6-G$6-1)) TIA! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |