Count if - Help Neeed

[uswyne]

putting GR # in column B and result will show the total number of class admission.

A B C D E
Reg # GR# Class Class 1 2 (Answer should be 2, cause B5 is empty. that mean no confirm admission)
15 20 1 Class 2
20 19 2
21 21 1
22 1

 

[etaf]

i dont see the layout ?
or row 5
only 4 rows