COUNTIF for variables that meets a dynamic criteria

Hi guys, i'm new to this forum. I seldom need to create excel spreadsheet, so I don't know how to solve this simple solution (which i could with spss).

I am looking for a non-VBA solution because not all my employees/ clients have VBA-access.

Problem

Column A: Group Identifier
Column B: Test 1 Score
Column C: Test 2 Score
Column D: G2 - Group required
Column E: E2 - Criteria for Test 1 (e.g. >=30)
Column F: F2 - Criteria for Test 2 (e.g. <=50)
Column G: G2 - Generated Results

I want to create a spreadsheet that allows the user to count the number of entries that meets a user-specified criteria, which they can key in on Column E and Column F.

The user will also be able to identify the group identifier (e.g. class A) for the counting.

Example the user wants to find out the number of people in class A that scores higher and equal to 30 for Test 1 AND/ OR score lower and equal to 50 for Test 2.

The user will key in "A" in cell G2, ">=30" in cell E2 and "<=50" in cell F2.

I tried using COUNTIFS function, but i can't make it work to allow the AND/ OR condition.
I tried using SUMPRODUCT, but sum product won't allow me to specify the operant (i.e. <=, >=). The direction of operant is important, because the user need to be able to specify the criteria.

I have added a sample excel sheet.

Thanks in advance!