Hi All,
I have a daily report in which we record all the activities that we do for all the clients by the team members. Now a team member may handle upto 5 clients in a day. Each client may have upto 4 activities. I want a total of all the activities unit per client wherein i take the job ID as the base. I have done that using the SUM of SUMIFS, however i have to use SUMIFS with two criteria 20 times. Is there a simpler solution to this. I am attaching a sample sheet for your reference. I have not used the entire formula in the sample sheet.
Cheers
Bookmarks