Sumif with multiple criteria

Hi all, below is the table that I want to use for a sumif formula

Date Activity Point Agent Client
250213 OSA 1 John Tom
250213 OSA 1 John Tom
250213 OSA 1 John Mike

As long as the activity is done for the same client on the same day by the same agent, no matter how many duplicate entries, I would like to sum the points for only 1 activity. For example, in this case, John's total points will be 2 (1 for client Tom and 1 for client Mike).
Also, I want to leave the duplicate entries there and not remove them, as in my spreadsheet that are actually subactivities for each activity.

Could you please help me out with this? I'm stuck with my sumif formula.

Thanks and your help is much appreciated!

Example.xlsx

I've enetered the example data given into a spreadsheet.

I've then created another table which shows the date to look for and the agent. Then you need a column for each client, in this example Tom and Mike.
Using the COUNTIFS formula you can count how many times John worked with Tom on the 25th. This returns 2 for Tom which is right but becuse you want to class this as 1 i've put this formula inside an IF forumla. If the countif results is greater than or equal to 1 then return 1.if not return 0. This formula is applied to Mike also. Finally the points total column adds these together to give you your result.

You can use SUMIFS instead of COUNTIFS should you choose to.

Hi Harribone,

Apologies for the late reply. Your formula works great! Thanks you so much for your help!