Formula to calculate a number of students in an attendance sheet !

Hi there,

I am working on an attendance sheet where the name of the students, their gender (either "G" & "B"), and their respective categories (5 different categories) are in the continuous columns. Please note that everything is in random order. Now in the next 30/32 cells the dates are written in which a teacher puts either a "P" (for present) or an "A" (for absence) or even left it blank for absence. See the image for a better understanding:

sample.png

Now I need to calculate "How many students were present at least one day in different categories and gender"? i.e. for an example How many boy (B) students from category 2 (CAT2) attended the school at least 1 day.
Kindly note that we do not have to count "How many days a particular student attended the class?". That means for each student we have to search for only 1 "P" in the date cells. I tried many things like SUMPRODUCT, COUNTIFS etc. But nothing gave me the desired result.
Please help !
Thanks in advance!

Thank you for the response and sorry for the inconvenience. I am very new to this forum.
I am attaching an Excel demo file. In the 2nd sheet, I wrote the expected outcomes whereas the 1st sheet have the actual data.
Thank you !

Thank you @oeldere. Though I did not use Pivot table and did some COUNTIFS with the column you added to get the desired result

Thank you Shiva for your response. Though I could not get it completely (I am completely new for all this). Column are hidden or missing (11-12, 14-15, 17-19) and there are only one gender "G". Any ways, my problem has been solved.
Thanks again for your help. I appreciate it.