using countif function

[Excel Enthusiast]

I need to exptract the number of Male & Females in a particular class. Trying to use Countif & vlookup since last two days but i'm making some mistake. So please help me out on this issue at the earliest. Thank You. Pritpal Singh

 

[bosco_yip]

Try,

In Q2, formula copied down:

=COUNTIFS(F:F,Q$1,G:G,P2)

Or,

you can use "used range" to save some memory, and become like that:

=COUNTIFS(F$2:F$187,Q$1,G$2:G$187,P2)