The following code occurs 231 times each on six sheets. That's 1386 calculations for every new entry.
Anyone have a great idea for speeding this up?
Anyone have a great idea for speeding this up?
Code:
=SUMPRODUCT(--(OVERTIME!$B$4:$B$2048>=DATA!D$2),--(OVERTIME!$B$4:$B$2048<=DATA!D$3),--(OVERTIME!$K$4:$K$2048="Monday"),--(OVERTIME!$D$4:$D$2048=TRUE),--(OVERTIME!$C$4:$C$2048=1),OVERTIME!$G$4:$G$2048)
+SUMPRODUCT(--(OVERTIME!$B$4:$B$2048>=DATA!D$2),--(OVERTIME!$B$4:$B$2048<=DATA!D$3),--(OVERTIME!$K$4:$K$2048="Monday"),--(OVERTIME!$D$4:$D$2048=TRUE),--(OVERTIME!$C$4:$C$2048=1),OVERTIME!$H$4:$H$2048)
+SUMPRODUCT(--(OVERTIME!$B$4:$B$2048>=DATA!D$2),--(OVERTIME!$B$4:$B$2048<=DATA!D$3),--(OVERTIME!$K$4:$K$2048="Monday"),--(OVERTIME!$D$4:$D$2048=TRUE),--(OVERTIME!$C$4:$C$2048=1),OVERTIME!$I$4:$I$2048)