Forum Discussion
Looking to Merge and Sum Duplicates from Multiple Fields
An additional example in Sheet2 of the following attached document. Two alternative solutions/formulations/structuring (Yellow and green).
Hi, you can use a SUMIF function for that. Please see attached document with proposed solution. By the way, I also used a UNIQUE function to clean duplicates and show the sum of the time spent for unique participants.
=SUMIF($A$1:$A$12,E1,$B$1:$B$12)
Remember to format cells as "Time".
If you wanted to have the unique names and the sums together in the same returned array, you can use:
=LET(uniqueNames,UNIQUE(A1:A12),sums,SUMIF(A1:A12,BYROW(uniqueNames,LAMBDA(r,r)),B1:B12),HSTACK(uniqueNames,sums))
An additional example in Sheet2 of the following attached document. Two alternative solutions/formulations/structuring (Yellow and green).
- This was great. Thank you! Thank you! THANK YOU!
So glad it worked! Please consider marking the reply as a solution so any other future user can refer to it as a solved discussion!