Forum Discussion
Solved
Count unique text value with specific text criteria
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.
=COUNTIFS(C2:C1000, "M Haseeb", E2:E1000, "P") + COUNTIFS(C2:C1000, "M Haseeb", E2:E1000, "Ph")/2
=COUNTIFS(C2:C1000, "M Haseeb", E2:E1000, "P") + COUNTIFS(C2:C1000, "M Haseeb", E2:E1000, "Ph")/2
HansVogelaar Thank you Hans. It worked.
