Countifs Multiple Criteria Met

Trying to create a Countifs formula in attached excel sheet to solve the following:

if the Slate row = 3 (or any given number) then return the number of times a number >=300 occurs from that particular numbered column. If we use 3 then it would look in columns H & V.
Proj 1U would only return the count from the 4:23 range
and a second formula to pull the same results for:
Proj 2U to return the count from the 27:46 range

In this example the Proj 1U would return a 1 count (V16)
and Proj 2U would also return a 1 count (V33).

Thank you so much in advance.
Gary

Countifs is an assumed solution, it is not suitable for this task. Assuming that you don't want the average figure in the last row of each table to be counted.

Start by copying "Proj 1u:" from A3 to A4:A23. Every cell needs to be filled for a formula to work, not just the top one. Repeat for "Proj 2u:" and any others you may have in your proper sheet.

Then you can get your result with.

=SUMPRODUCT(($A$4:$A$47="Proj 1u:")*($B$1:$AE$1=3)*($B$4:$AE$47>=300))

I thought about that but it promotes unnecessary use of a volatile function and also assumes that the number of rows will be uniform for each table.

The difference between an answer and a solution...

Thank you for the replies. They boh worked!