请大神优化公式,exls版本为2016,谢谢!
=SUMIF(Sheet21!J:J,$W$5,Sheet21!L:L)+SUMIF(Sheet21!J:J,$W$5,Sheet21!M:M)
+SUMIF(Sheet22!J:J,$W$5,Sheet22!L:L)+SUMIF(Sheet22!J:J,$W$5,Sheet22!M:M)
+SUMIF(Sheet23!J:J,$W$5,Sheet23!L:L)+SUMIF(Sheet23!J:J,$W$5,Sheet23!M:M)
+SUMIF(Sheet24!J:J,$W$5,Sheet24!L:L)+SUMIF(Sheet24!J:J,$W$5,Sheet24!M:M)
+SUMIF(Sheet25!J:J,$W$5,Sheet25!L:L)+SUMIF(Sheet25!J:J,$W$5,Sheet25!M:M)
+SUMIF(Sheet26!J:J,$W$5,Sheet26!L:L)+SUMIF(Sheet26!J:J,$W$5,Sheet26!M:M)
+SUMIF(Sheet27!J:J,$W$5,Sheet27!L:L)+SUMIF(Sheet27!J:J,$W$5,Sheet27!M:M)
+SUMIF(Sheet28!J:J,$W$5,Sheet28!L:L)+SUMIF(Sheet28!J:J,$W$5,Sheet28!M:M)
|