countifs with date

[uswyne]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Class[/TD]
[TD]Admission[/TD]
[TD]Withdrawal[/TD]
[/TR]
[TR]
[TD]PG[/TD]
[TD]11/16/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PG[/TD]
[TD]11/16/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nur[/TD]
[TD]08/1/17[/TD]
[TD]11/16/17[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Required answer

[TABLE="width: 500"]
<tbody>[TR]
[TD]Class[/TD]
[TD]Admission[/TD]
[TD]Withdrawal[/TD]
[/TR]
[TR]
[TD]PG[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nur[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Kindly Help

 

[alansidman]

here's a tutorial

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

 

[Aladin Akyurek]

[TABLE="class: grid, width: 466"]
<tbody>[TR]
[TD]Class[/TD]
[TD]Admission[/TD]
[TD]Withdrawal[/TD]
[TD][/TD]
[TD][/TD]
[TD]Class[/TD]
[TD]Admission[/TD]
[TD]Withdrawal[/TD]
[/TR]
[TR]
[TD]PG[/TD]
[TD="align: right"]11/16/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]PG[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PG[/TD]
[TD="align: right"]11/16/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nur[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Nur[/TD]
[TD="align: right"]8/1/2017[/TD]
[TD="align: right"]11/16/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In G2 enter, copy across, and down:

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