英文:
Excel, SUM across all sheets not including last sheet when adding new row
问题
=SUM('2023年4月10日:2024年3月10日'!E15)
=SUM('2023年4月10日:2024年2月10日'!E16)
这个公式的问题是，无论添加多少新行，公式的结束部分都不会保持为“10th March 2024”，而是变成倒数第二个工作表的名称“10th February 2024”。
英文:
I have a simple SUM for every corresponding cell from all 12 sheets (12 months) ranging from April 2023-March 2024
This works fine, but when I add a new line (a new customer) it only adds the SUM of 11 sheets (months), not all 12.
My formula is:
=SUM('10th April 2023:10th March 2024'!E15)
When I add a new line (to add a new customer) it changes to this:
=SUM('10th April 2023:10th February 2024'!E16)
The end of the formula for some reason won't stay as my final sheet name "10th March 2024" but my 2nd to last, "10th February 2024". This happens no matter how many new lines I add too.
I've dragged the same formula across the entire row, yet when I add a new table line the formula for the new lines changes to months April-February rather than April-March
答案1
得分: 0
我终于找到了我自己问题的答案！我不得不在我的表格上"清除内容"，然后重新编写公式并复制它。每当我向表格添加新行时，它都在使用旧的公式，而不更新为新的公式。清除表格的内容解决了这个问题。
英文:
I've finally worked out the answer to my own question!
I had to "clear contents" on my table and re-write the formula and copy it down.
Every time I added a new line to the table it was using the old formula and wasn't updating to the new one.
Clearing the contents of the table fixed this.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论