Forum Discussion
MaeveO16
Jul 03, 2023Copper Contributor
Adding numerical cells based on names in another column.
Hello!! I am working on an Excel spreadsheet where people can copy and paste in their data, then there is a column that will add up time durations and display it for them. The issue is, is that there...
OliverScheurich
Jul 03, 2023Gold Contributor
=MAP(C2:C18,E2:E18,LAMBDA(dur,team,SUMIFS(C2:dur,E2:team,team)))Does this return the intended result?