A simple way to solve this problem is with the COUNTIFS function.
Both approaches are explained below.
Notice in the formulas above, we are hardcoding the numbers into the formula.
For a detailed overview of concatenation, seeHow to concatenate in Excel.
Notice that by design, the FREQUENCY function always returns a count forone more binthan is provided.
With a Pivot Table
APivot Tableis another way to solve this problem.
Seethis video for a similar example.
The number of rows and columns to remove is provided by separaterowsandcolumnsarguments.
