Please try at E3
=SUM(
IFERROR(LOOKUP(EOMONTH(B2,0),ABSL_T!B:D)*SUMIFS(ABSL_T!E:E,ABSL_T!B:B,"<"&EDATE(B2,1)),),
IFERROR(LOOKUP(EOMONTH(B2,0),BOIAXA_T!B:D)*SUMIFS(BOIAXA_T!E:E,BOIAXA_T!B:B,"<"&EDATE(B2,1)),),
IFERROR(LOOKUP(EOMONTH(B2,0),CanRob_E!B:D)*SUMIFS(CanRob_E!E:E,CanRob_E!B:B,"<"&EDATE(B2,1)),),
IFERROR(LOOKUP(EOMONTH(B2,0),Kotak_Std_M!B:D)*SUMIFS(Kotak_Std_M!E:E,Kotak_Std_M!B:B,"<"&EDATE(B2,1)),),
IFERROR(LOOKUP(EOMONTH(B2,0),'L&T_Emerging_B'!B:D)*SUMIFS('L&T_Emerging_B'!E:E,'L&T_Emerging_B'!B:B,"<"&EDATE(B2,1)),)
)
Bookmarks