countifs with date

[uswyne]

Class	Admission	Withdrawal
PG	11/16/17
PG	11/16/17
Nur	08/1/17	11/16/17

<tbody>
</tbody>

Required answer

Class	Admission	Withdrawal
PG	2
Nur	1	1

<tbody>
</tbody>

Kindly Help

 

[alansidman]

here's a tutorial

https://support.office.com/en-us/ar...ondition-976d0074-245d-49e6-bf5f-1207983f82ed

 

[Aladin Akyurek]

Class	Admission	Withdrawal			Class	Admission	Withdrawal
PG	11/16/2017				PG	2
PG	11/16/2017				Nur	1	1
Nur	8/1/2017	11/16/2017

<tbody>
</tbody>

In G2 enter, copy across, and down:

=SUMPRODUCT(--ISNUMBER(B$2:B$4),--($A$2:$A$4=$F2))