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!
|