英文:
Google Sheets: Formula to Sum all the Cell Values Across Multiple Columns Associated with Max Date in Date Column
问题
我想编写Google表格公式，使其通过日期列搜索，找到最大日期，然后对与最大日期相关的col1、col2和col3的值进行求和。这个总和会填充到同一Google表格中的不同单元格中。
由于日期不总是按照时间顺序排列，新日期将通过BigQuery自动刷新到我的表中，这就是我想要动态执行此操作的原因。
英文:
I have a Google Sheet that is connected to BigQuery so the table automatically generates new rows of data every week. I have a pivot table output that looks like below:
I want to write Google Sheet formula so that it searches through the date column, finds the max date, and then sums the values in col1, col2, and col3 associated with max date. This sum populates inside a different cell in the same Google Sheet.
The dates will not always be in chronological order and new dates will get automatically refreshed into my table via BigQuery which is why I want to find a formula to do this dynamically.
答案1
得分: 1
<!-- language-all: js -->
*You may try:*
=sum(filter(B:D,A:A=max(A:A)))
[![enter image description here][1]][1]
[1]: https://i.stack.imgur.com/FR8wK.png
英文:
<!-- language-all: js -->
You may try:
=sum(filter(B:D,A:A=max(A:A)))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论