yogi_Compute Row By Row Count Of Male and Female Students Present From Data In Table E:AF

Google Spreadsheet   Post  #2502

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-01-2018

question by: Ilias Antoniou
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/LTZOh5c3vKo;context-place=forum/docs
How to replace - improve COUNTIFS with Arrayformula or similar solution
Hello I would like to ask you for some help if it is possible. I have a series of Countifs which I need to replace by one Arrayformula. The  Countifs in each cell are:

=COUNTIFS($S2:2, "Present" , $S$1:$1, "* M, *" )

=COUNTIFS($S3:3, "Present" , $S$1:$1, "* M, *" )

=COUNTIFS($S4:4, "Present" , $S$1:$1, "* M, *" )

=COUNTIFS($S5:5, "Present" , $S$1:$1, "* M, *" )

=.....

....

I need an arrayformula which will run from the first cell and replace the above mentioned series of Countifs.

Thanks in advance

Ilias