Formula:
=IF(ISERROR(IF(L3=L4,SUMIFS(INDIRECT(L3&"!B:B"),INDIRECT(L3&"!A:A"),">="&'Daily Planner'!K3,INDIRECT(L3&"!A:A"),"<="&'Daily Planner'!K4),SUMIFS(INDIRECT(L3&"!B:B"),INDIRECT(L3&"!A:A"),">="&'Daily Planner'!K3,INDIRECT(L3&"!A:A"),"<="&'Daily Planner'!K4) + SUMIFS(INDIRECT(L4&"!B:B"),INDIRECT(L4&"!A:A"),">="&'Daily Planner'!K3,INDIRECT(L4&"!A:A"),"<="&'Daily Planner'!K4)))=TRUE,"",IF(L3=L4,SUMIFS(INDIRECT(L3&"!B:B"),INDIRECT(L3&"!A:A"),">="&'Daily Planner'!K3,INDIRECT(L3&"!A:A"),"<="&'Daily Planner'!K4),SUMIFS(INDIRECT(L3&"!B:B"),INDIRECT(L3&"!A:A"),">="&'Daily Planner'!K3,INDIRECT(L3&"!A:A"),"<="&'Daily Planner'!K4) + SUMIFS(INDIRECT(L4&"!B:B"),INDIRECT(L4&"!A:A"),">="&'Daily Planner'!K3,INDIRECT(L4&"!A:A"),"<="&'Daily Planner'!K4)))
Bookmarks