=IFNA(SUMIFS(OFFSET(北京!J:J,,MATCH(B4,北京!$J$3:$AC$3,0)-1),北京!B:B,">="&$H$2,北京!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(天津!J:J,,MATCH(B4,天津!$J$3:$AC$3,0)-1),天津!B:B,">="&$H$2,天津!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(杭州!J:J,,MATCH(B4,杭州!$J$3:$AC$3,0)-1),杭州!B:B,">="&$H$2,杭州!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(深圳!J:J,,MATCH(B4,深圳!$J$3:$AC$3,0)-1),深圳!B:B,">="&$H$2,深圳!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(上海!J:J,,MATCH(B4,上海!$J$3:$AC$3,0)-1),上海!B:B,">="&$H$2,上海!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(广州!J:J,,MATCH(B4,广州!$J$3:$AC$3,0)-1),广州!B:B,">="&$H$2,广州!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(南京!J:J,,MATCH(B4,南京!$J$3:$AC$3,0)-1),南京!B:B,">="&$H$2,南京!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(酒泉!J:J,,MATCH(B4,酒泉!$J$3:$AC$3,0)-1),酒泉!B:B,">="&$H$2,酒泉!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(阜阳!J:J,,MATCH(B4,阜阳!$J$3:$AC$3,0)-1),阜阳!B:B,">="&$H$2,阜阳!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(大连!J:J,,MATCH(B4,大连!$J$3:$AC$3,0)-1),大连!B:B,">="&$H$2,大连!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(西安!J:J,,MATCH(B4,西安!$J$3:$AC$3,0)-1),西安!B:B,">="&$H$2,西安!B:B,"<="&$I$2),0)
+IFNA(SUMIFS(OFFSET(厦门!J:J,,MATCH(B4,厦门!$J$3:$AC$3,0)-1),厦门!B:B,">="&$H$2,厦门!B:B,"<="&$I$2),0) |