=SUM(IF(Sheet1!$K$5:$K$705=A12,IF(Sheet1!$M$5:$M$7 05=1,"PSP*")))

I'm trying to get a number value on Sheet 2 for how many times a cell starts
with PSP but only if two cells over it states a predefined user name on
Sheet2 hence the A12 in the formula. Can anyone point me in the right
direction? I've asked alot of people and it seems to stump them. even when
they think they can do it it ussually results in an error or incorrect value.

exsample:

A B C
Joe 123 PSP12321323
Joe 132 INC12123424
Jack 123 PSP12132342
Jack 132 PSP12123424
Jack 123 INC12324213


The result I'm looking for is how many times does PSP show up next to a
given user