Count formulae

[Heera]

Hi,

I have two columns data in which, first column shown which employee is coming in which shift and second column i have data as Yes or No.

I need to count of Yes in each shift. Below is the table.

Shift	Yes/no	Shift	Count
3:30	Yes	17:30
17:30	No	19:30
19:30	No	20:30
17:30	Yes	21:30
19:30	No	22:30

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

Regards,
Heera

 

[Smitty]

Welcome to the Board!

Something like this:

=COUNTIFS($A$2:$A$6,C2,$B$2:$B$6,"Yes")

HTH,