I did receive this possible solution but it is counting one variable twice, the line that is highlighted. I had to do another data sample set to explain better.



=IF(B2<>B3,SUMIF(B$2:B2,B2,F$2:F2)+SUMIFS(E$2:E2,K$2:K2,"<>"&TODAY(),I$2:I2,"Y",B$2:B2,B2)+SUMIFS(E$2:E2,G$2:G2,"Y",B$2:B2,B2),"")