SOLVED

Looking to Merge and Sum Duplicates from Multiple Fields

Copper Contributor

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? 

 

4 Replies

@mrrpaj 

 

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))

best response confirmed by mrrpaj (Copper Contributor)
Solution

@mrrpaj 

 

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!

@mrrpaj 

 

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!

1 best response

Accepted Solutions
best response confirmed by mrrpaj (Copper Contributor)
Solution

@mrrpaj 

 

An additional example in Sheet2 of the following attached document. Two alternative solutions/formulations/structuring (Yellow and green). 

View solution in original post