Find how many matches based on two criteria

I work for a trucking company and I have a list that shows the amount of loads done by each driver. Each row represents a different load (From origin to destination).

I need to find out if a driver works more than one load on that day. I want the column to display the number load this driver is on for the day.

December Template Test 12-18.xlsx

The column i'm working on is "AB" entitled "Driver Loads".


I have found a simple countif statement that works to tell me which number loads in that day based on all of the drivers.

Please Login or Register  to view this content.

I need it to be driver specific as well.

Something like this

Please Login or Register  to view this content.

any help is greatly appreciated

Try these
=COUNTIFS(C$3:C3,C3,M$3:M3,M3)

Formula:

Please Login or Register  to view this content.

SMH so simple I'm embarassed i didn't think of it


Thank you!