英文:
Trying to sum elements in a column based on comparing criteria between sheets
问题
I have two sheets: Backlog and Sprint. The backlog items are numbered 1, 2, 3, 4 and so on, and the sprint items are numbered 1.1, 1.2, 1.3, 1.4 and so on.
In the backlog I need to sum the hours spent from column J3:J in the sprint sheet for the items with the same initial ID (1, 2, 3, 4...).
I'm trying to do this but I get 0, even though the sum of column J with values 1.X in col A is 4.5.
=SUMIF(A3,"="&INDEX(SPLIT('Sprint 1'!$A$3:$A,"."),1),'Sprint 1'!$J$3:$J)
The IDs are strings, if that matters. They need to be so because...reasons
英文:
I have two sheets: Backlog and Sprint. The backlog items are numbered 1, 2, 3, 4 and so on, and the sprint items are numbered 1.1, 1.2, 1.3, 1.4 and so on.
In the backlog I need to sum the hours spent from column J3:J in the sprint sheet for the items with the same initial ID (1, 2, 3, 4...).
I'm trying to do this but I get 0, even though the sum of column J with values 1.X in col A is 4,5.
=SUMIF(A3;"="&INDEX(SPLIT('Sprint 1'!$A$3:$A;".");1); 'Sprint 1'!$J$3:$J)
The IDs are strings, if that matters. They need to be so because...reasons
答案1
得分: 1
以下是翻译好的内容:
=SUMIF(MAP(A:A;LAMBDA(Z;INDEX(SPLIT(Z;"."));1)));D1;B:B)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论