Formula for Summing Total Sales Count by Submission Date and Agent Name

[Zee996]

Hello everyone,

I am working with a dataset and need help with an Excel formula. I'm looking for a way to calculate the total sales count based on the submission date and the agent's name. I want the sales count value to be summed and displayed once for each date of submission, while other similar dates against the Agent name should remain blank.

This is what my data looks like:

Please let me know if this is possible.

Thank you for your help.

 

[hagia_sofia]

Would this work for you:

=IF(COUNTIFS(A$2:A2,A2,C$2:C2,C2)=1,SUMIFS($B$2:$B$11,$A$2:$A$11,A2,$C$2:$C$11,C2),"")

 

[Zee996]

Would this work for you:

=IF(COUNTIFS(A$2:A2,A2,C$2:C2,C2)=1,SUMIFS($B$2:$B$11,$A$2:$A$11,A2,$C$2:$C$11,C2),"")

This is working. Thank you so much for your help.