The COUNTIFS function counts the number of cells based on single or multiple criteria. In our example, we will count cells with number values greater than 30 and smaller than 50.
criteria_range1 (A4:A9)- The range of cells to count based on criteria1.
1– Type =COUNTIFS, select cell ranges A4:A9 to count based on critera1, which is to count greater than 30.
2– Select range2 and criteria2, A4:A9 and "<50".