Count number of occurrences based on criteria in multiple columns and rows

Hello,

If I understand correctly, you want to count the number of OTs that are greater than 0 in each row. What name that row belongs to is not really affecting this. Starting in row 5 and copied down, this formula

=COUNTIFS($C$4:$Q$4,"OT",C5:Q5,">0")

Will produce the numbers you specified as the desired result.

cheers, teylyn

Try this...

=COUNTIFS(C$4:Q$4,"OT",C5:Q5,">0")

Based on your data structure it doesn't look like you need to know the employee name. However, if you want to be able to enter an employee name and get the result then try this version:

B18 = employee name

=COUNTIFS(C4:Q4,"OT",INDEX(C5:Q16,MATCH(B18,B5:B16,0),0),">0")

You're welcome. Thanks for the feedback!