I am trying to enter a formula that will count when the name Kara is listed and the status is listed. I keep either getting an error or it will double count. Please help. The end goal is to find ou how many each person has in each status listed.
Example:
=COUNTIFS([CSMNAME]:[CSM NAME], "Kara", Status:Status, "Locked")