Count unique text value with specific text criteria

[a1tarif]

I want to Sum all M Haseeb Paid leave(P) as value 1, and M Haseeb's Ph as 0.5

Only for one person in one cell. 

[#2 · Accepted solution]

@a1tarif 

=COUNTIFS(C2:C1000, "M Haseeb", E2:E1000, "P") + COUNTIFS(C2:C1000, "M Haseeb", E2:E1000, "Ph")/2

[#3]

@Hans Vogelaar Thank you Hans. It worked.