Using counif and index in excel

Hey guys,

I am trying to count data that spans multiple columns, but only where it matches someone's name. My issue is that I can't get the formula to count the criteria and match it to a name. For eg. Check sample sheet attached. In columns L & M has conditions of either yes or no. In column A I have sample names of workers and in Column B I have the title off projects they worked. I want the formula to identify if a worker received "yes" in Columns L & M for all the projects they've worked and return an answer. Is this possible? Not sure if I'm making sense.