Need formula to filter student information based on a condition of getting subject mark less than 50

Hi I have two ranges of data, Ranges 1 and 2, which represent the student marks in the first and second semesters respectively.  I want to collect or filter the students of ranges 1 and 2 based on ...