In article ,
gpktm wrote:

It not accepts the function in H4 cell.

That's probably because your version of Excel uses a semi-colon as a
separator instead of a comma. Try...

=COUNTIF($B$3:$C$8;G4)

And how about the draws?

=SUMPRODUCT((($B$3:$B$8=G4)*($D$3:$D$8=$E$3:$E$8)) +(($C$3:$C$8=G4)*($E$3:
$E$8=$D$3:$D$8)))

Hope this helps!