Forum Discussion
Looking to Merge and Sum Duplicates from Multiple Fields
I have a Zoom report that lists attendees by their Display Name/Number and the Length of Time on the call. A new entry is added for each time an attendee joins or rejoins the call. In this instance, I have someone who has three call logs, that I'd like to merge and sum to get the total time spent on the call by the attendee.
Any advice on an efficient way to do this without going line by line?
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!
