I need a formula to count the number of rows in which two of it's cells meet
3 different criteria.

So, it counts the number of rows where one rage of cells D2:D231 is equal to
23, and another range F2:F231 is greater than or equal to C5 and less than D5.

I've tried a bunch of variations including IF, AND, and COUNTIF, but I'm not
getting the right numbers. Thx.