Hi AhoyNC,
Yes something like that, actually that is the code I am using, something like below
'=(SUMIFS($J:$J,$C:$C,$C14,$D:$D,$D14,$A:$A,MAX(IF($C:$C=$C14,IF($D:$D=$D14,IF($A:$A<DATE(YEAR($A14),MONTH($A14),DAY($A14)),$A:$A)))))+SUMIFS($E:$E,$C:$C,$C14,$D:$D,$D14,$A:$A,MAX(IF($C:$C=$C14,IF($D:$D=$D14,IF($A:$A=DATE(YEAR($A14),MONTH($A14),DAY($A14)),$A:$A))))))-SUMIFS($F:$F,$C:$C,$C14,$D:$D,$D14,$A:$A,MAX(IF($C:$C=$C14,IF($D:$D=$D14,IF($A:$A<DATE(YEAR($A14),MONTH($A14),DAY($A14)),$A:$A)))))-SUMIFS($H:$H,$C:$C,$C14,$D:$D,$D14,$A:$A,MAX(IF($C:$C=$C14,IF($D:$D=$D14,IF($A:$A<DATE(YEAR($A14),MONTH($A14),DAY($A14)),$A:$A)))))
<DATE(YEAR($A14),MONTH($A14),DAY($A14)),$A:$a)))))+sumifs($e:$e,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a=date(year($a14),month($a14),day($a14)),$a:$a))))))-sumifs($f:$f,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a<date(year($a14),month($a14),day($a14)),$a:$a)))))-sumifs($h:$h,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a<date(year($a14),month($a14),day($a14)),$a:$a)))))<date(year($a14),month($a14),day($a14)),$a:$a)))))+sumifs($e:$e,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a=date(year($a14),month($a14),day($a14)),$a:$a))))))-sumifs($f:$f,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a<date(year($a14),month($a14),day($a14)),$a:$a)))))-sumifs($h:$h,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a<date(year($a14),month($a14),day($a14)),$a:$a)))))
The problem is, my excel is getting too slow with that array. do you think we can get an alternative with that formula?</DATE(YEAR($A14),MONTH($A14),DAY($A14)),$A:$a)))))+sumifs($e:$e,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a=date(year($a14),month($a14),day($a14)),$a:$a))))))-sumifs($f:$f,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a<date(year($a14),month($a14),day($a14)),$a:$a)))))-sumifs($h:$h,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a<date(year($a14),month($a14),day($a14)),$a:$a)))))<date(year($a14),month($a14),day($a14)),$a:$a)))))+sumifs($e:$e,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a=date(year($a14),month($a14),day($a14)),$a:$a))))))-sumifs($f:$f,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a<date(year($a14),month($a14),day($a14)),$a:$a)))))-sumifs($h:$h,$c:$c,$c14,$d:$d,$d14,$a:$a,max(if($c:$c=$c14,if($d:$d=$d14,if($a:$a<date(year($a14),month($a14),day($a14)),$a:$a)))))