Analising scores per subjects

Hello good people!
I need a formula to analyze the attached sheet.
I need to know
1-Number of students that passed with 70% and above in English, Maths and Biology
2- Number of students that passed with 50%-69% and above in English, Maths and Biology
3- Number of students that scored below 50% in English, Maths and Biology
4-Number of student that where absent for each of the subjects (English, Maths, biology)
Note: Total of all the columns per subject must be equal to the total number of students in the sheet
Thanks

Did it with COUNTIFs mostly.

BTW, a lot of "blank" cells were filled with zeros that were formatted with white text (on white cell fill). I handled those as zeros instead of absences.

@ben_hensel Thanks alot. but those zeros also represents absents as such to us zero or blanks spaces is regarded as NO MARK or ABSENT

I've include a SUMIF solution and a Pivot Table solution on the "Pivot" TAB

Originally Posted by Xx7

I've include a SUMIF solution and a Pivot Table solution on the "Pivot" TAB

I have seen it it also works well for me