电子表格EXCEL里如何实现根据现在日期所在的月份进行动态数据计算?
2025-01-20 15:09:52
1.EXCEL里如何实现根据现在日期所在的月份进行动态数据计算?
1问可以用公式：=SUM(A1:INDIRECT("A"&MONTH(TODAY())))2问可以用公式：=INDIRECT("A"&MONTH(TODAY（)）） 如果是A1 B1 C1 D1 E1 F11问可以用公式：=SUM(INDIRECT("A1:"&INDEX({"A1","B1","C1","D1","E1","F1"},MONTH(TODAY()))))2问可以用公式：=INDIRECT(INDEX({"A1","B1","C1","D1","E1","F1"},MONTH(TODAY())))。
2.EXCEL里如何实现根据现在日期所在的月份进行动态数据计算
1问可以用公式：=SUM(A1:INDIRECT("A"&MONTH(TODAY())))2问可以用公式：=INDIRECT("A"&MONTH(TODAY（)）） 如果是A1 B1 C1 D1 E1 F11问可以用公式：=SUM(INDIRECT("A1:"&INDEX({"A1","B1","C1","D1","E1","F1"},MONTH(TODAY()))))2问可以用公式：=INDIRECT(INDEX({"A1","B1","C1","D1","E1","F1"},MONTH(TODAY())))。