如何将以下公式合并或简化
SUMIF('2018.03'!$A$8:$A$37,$A$5:$A$36,'2018.03'!AH$8:AH$37)+SUMIF('2018.04'!$A$8:$A$37,$A$5:$A$36,'2018.04'!AH$8:AH$37)+SUMIF('2018.05'!$A$8:$A$37,$A$5:$A$36,'2018.05'!AH$8:AH$37)+SUMIF('2018.06'!$A$8:$A$37,$A$5:$A$36,'2018.06'!AH$8:AH$37)+SUMIF('2018.07'!$A$8:$A$37,$A$5:$A$36,'2018.07'!AH$8:AH$37)+SUMIF('2018.08'!$A$8:$A$37,$A$5:$A$36,'2018.08'!AH$8:AH$37)+SUMIF('2018.09'!$A$8:$A$37,$A$5:$A$36,'2018.09'!AH$8:AH$37)+SUMIF('2018.10'!$A$8:$A$37,$A$5:$A$36,'2018.10'!AH$8:AH$37)+SUMIF('2018.11'!$A$8:$A$39,$A$5:$A$36,'2018.11'!AH$8:AH$39)+SUMIF('2018.12'!$A$8:$A$39,$A$5:$A$36,'2018.12'!AH$8:AH$39)+SUMIF('2019.01'!$A$8:$A$39,$A$5:$A$36,'2019.01'!AH$8:AH$39)
用SUMIF函数的方法公式优化为:
=SUMIF('2018.03'!$A$8:$A$37,$A$5,'2018.03'!AH$8)
+SUMIF('2018.04'!$A$8:$A$37,$A$5,'2018.04'!AH$8)
+SUMIF('2018.05'!$A$8:$A$37,$A$5,'2018.05'!AH$8)
+SUMIF('2018.06'!$A$8:$A$37,$A$5,'2018.06'!AH$8)
+SUMIF('2018.07'!$A$8:$A$37,$A$5,'2018.07'!AH$8)
+SUMIF('2018.08'!$A$8:$A$37,$A$5,'2018.08'!AH$8)
+SUMIF('2018.09'!$A$8:$A$37,$A$5,'2018.09'!AH$8)
+SUMIF('2018.10'!$A$8:$A$37,$A$5,'2018.10'!AH$8)
+SUMIF('2018.11'!$A$8:$A$39,$A$5,'2018.11'!AH$8)
+SUMIF('2018.12'!$A$8:$A$39,$A$5,'2018.12'!AH$8)
+SUMIF('2019.01'!$A$8:$A$39,$A$5,'2019.01'!AH$8)
下一篇:编个选股公式