Countifs Multiple Criteria Met

[GParis]

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

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA BB CC DD EE 1 Slate 8 8 6 7 8 6 3 11 5 6 8 7 5 6 4 10 4 10 4 5 3 8 7 5 8 6 6 4 6 9 2 9-Feb 8-Feb 7-Feb 6-Feb 5-Feb 4-Feb 3-Feb 2-Feb 1-Feb 31-Jan 30-Jan 29-Jan 28-Jan 27-Jan 26-Jan 25-Jan 24-Jan 23-Jan 22-Jan 21-Jan 20-Jan 19-Jan 18-Jan 17-Jan 16-Jan 15-Jan 14-Jan 13-Jan 12-Jan 11-Jan 3 Proj 1U: 4 283.00 348.50 325.75 327.75 294.50 297.00 250.50 317.25 261.00 283.75 279.50 294.25 267.75 296.25 295.25 285.50 289.00 346.25 268.00 284.00 299.50 267.75 197.50 335.25 320.50 291.75 338.50 237.75 257.50 344.75 5 293.50 346.75 306.75 305.00 300.50 284.50 253.00 313.00 296.25 303.75 294.50 304.25 284.75 291.50 276.50 309.00 296.25 328.50 259.25 275.00 262.50 255.75 215.50 322.00 334.75 272.00 337.50 259.50 280.00 355.25 6 281.75 327.00 285.75 316.50 273.50 287.75 234.50 350.50 275.75 315.50 316.75 277.25 274.75 262.50 292.25 271.50 337.00 327.00 323.50 272.25 257.50 295.00 217.00 313.50 325.75 296.25 338.50 244.00 274.50 327.50 7 274.25 313.00 344.50 293.75 286.75 282.25 256.00 311.25 303.50 268.75 285.75 323.00 211.75 264.00 272.50 304.25 300.75 347.75 285.75 268.25 269.50 266.75 201.25 334.50 296.75 284.75 348.75 222.00 244.00 335.50 8 290.25 338.00 339.00 339.50 287.50 297.00 244.75 317.75 283.25 280.50 313.50 297.00 259.50 317.00 276.75 324.00 303.50 351.50 277.00 264.75 231.75 267.75 209.25 314.25 305.50 267.25 316.00 263.50 280.00 318.25 9 278.00 317.75 334.75 293.50 300.75 309.00 233.25 340.00 292.00 294.00 296.50 292.25 245.75 303.75 280.75 276.00 340.25 345.25 287.25 277.25 266.50 266.00 223.50 338.50 305.50 278.00 318.75 242.25 280.75 365.25 10 264.00 355.50 278.25 301.00 313.25 326.75 245.50 346.25 290.50 319.75 306.00 277.00 281.50 282.50 293.50 246.25 316.75 356.75 296.00 269.25 239.75 269.75 231.00 300.75 323.50 298.50 301.75 244.25 264.25 340.50 11 286.00 311.50 327.75 281.75 272.25 292.00 251.25 326.50 289.75 315.25 320.00 279.75 251.75 291.25 265.50 319.25 266.50 337.25 294.25 275.75 255.50 268.25 200.25 304.75 303.75 340.25 275.25 248.25 235.25 338.50 12 289.75 323.50 346.25 307.50 305.50 288.50 271.75 315.00 296.75 281.25 314.50 299.75 241.00 331.00 273.50 266.75 293.75 337.00 271.25 267.75 272.50 265.25 264.00 325.25 308.00 330.25 297.00 239.25 271.25 349.75 13 288.25 339.00 296.25 348.25 293.25 294.75 267.00 328.75 255.25 311.50 316.75 273.25 270.00 276.00 297.25 291.00 308.00 326.75 307.00 257.25 290.75 282.75 234.00 335.00 319.00 298.25 342.00 249.50 262.50 321.25 14 280.75 327.00 289.75 284.75 300.25 296.00 258.50 327.25 262.50 285.75 300.75 300.25 256.25 308.00 284.50 237.00 286.25 327.00 284.00 266.25 291.25 260.25 196.00 291.50 326.50 318.75 295.75 242.25 279.75 330.00 15 293.00 319.00 303.00 309.75 282.50 331.75 227.25 313.75 286.25 316.25 260.00 283.25 281.00 268.25 275.75 289.00 258.75 326.25 328.25 256.75 221.00 285.75 253.00 326.00 310.50 281.00 296.00 245.25 255.00 323.25 16 286.75 340.75 299.25 303.50 289.50 280.00 248.00 313.50 266.25 289.75 297.25 309.00 264.00 333.50 288.00 315.75 312.50 329.00 261.25 268.25 301.25 257.00 195.75 322.25 306.25 304.25 319.00 240.75 239.00 341.75 17 284.50 319.25 332.75 299.50 270.50 307.50 257.25 320.00 273.25 327.00 338.50 292.00 266.00 290.75 294.50 305.25 306.75 325.00 282.25 270.25 227.00 278.50 246.75 305.75 317.75 309.25 339.00 231.00 248.50 355.25 18 292.25 350.00 274.25 314.00 280.25 328.50 253.75 335.00 300.00 283.25 310.50 277.25 288.75 280.75 274.75 277.00 335.25 341.50 274.25 235.00 249.25 279.00 237.50 309.75 299.75 283.25 342.75 252.25 252.25 324.50 19 277.75 327.50 298.75 286.75 271.50 290.50 256.75 320.75 271.75 292.00 293.25 291.25 267.25 287.00 250.50 283.00 235.25 334.25 278.75 265.50 223.25 282.25 242.00 329.00 308.00 267.50 338.00 251.50 271.00 323.75 20 288.75 291.50 323.75 290.75 288.75 306.25 239.50 310.75 278.75 307.50 294.00 311.75 231.00 310.25 294.00 261.25 304.00 304.75 298.25 279.25 249.75 277.50 226.75 321.75 308.50 296.00 288.00 243.25 231.50 338.00 21 290.00 316.50 285.50 307.50 277.50 310.50 272.75 311.75 242.50 305.25 293.50 279.75 234.25 257.75 256.00 291.00 318.25 350.00 260.50 225.75 265.25 272.00 218.00 309.25 308.50 262.25 340.25 222.00 301.75 321.00 22 289.00 302.50 335.00 288.50 289.50 303.00 282.50 340.00 256.75 334.25 273.00 284.75 267.25 294.75 276.75 265.00 263.25 328.25 269.25 265.25 259.25 281.50 209.25 310.50 322.50 293.25 305.25 260.75 229.75 329.50 23 309.00 328.00 332.75 326.00 293.50 278.25 235.00 298.50 289.50 301.50 284.50 310.25 259.75 312.25 242.50 291.50 263.25 335.25 279.75 267.50 260.00 269.50 272.50 318.25 305.75 276.00 324.00 255.75 246.00 334.50 24 286.03 327.13 312.99 306.28 288.58 299.59 251.94 322.88 278.58 300.83 299.45 292.86 260.20 292.95 278.05 285.46 296.76 335.26 284.29 265.56 259.65 272.41 224.54 318.39 312.85 292.44 320.10 244.75 260.23 335.90 25 26 Proj 2U: 27 283.00 348.50 325.75 327.75 294.50 297.00 250.50 317.25 261.00 283.75 279.50 294.25 267.75 296.25 295.25 285.50 289.00 346.25 268.00 284.00 299.50 267.75 197.50 335.25 320.50 291.75 338.50 237.75 257.50 344.75 28 293.50 346.75 306.75 305.00 300.50 287.75 253.00 311.25 296.25 303.75 294.50 304.25 284.75 291.50 292.25 309.00 296.25 327.00 259.25 268.25 262.50 255.75 215.50 313.50 334.75 272.00 338.50 259.50 280.00 318.25 29 281.75 313.00 285.75 293.50 273.50 284.50 234.50 350.50 275.75 315.50 285.75 323.00 274.75 262.50 272.50 271.50 337.00 347.75 323.50 277.25 231.75 295.00 201.25 300.75 325.75 296.25 316.00 244.00 274.50 365.25 30 290.25 338.00 339.00 307.50 286.75 297.00 244.75 317.75 292.00 268.75 316.75 297.00 211.75 264.00 276.75 276.00 316.75 356.75 285.75 264.75 266.50 266.75 209.25 325.25 305.50 284.75 318.75 242.25 244.00 338.50 31 286.00 317.75 296.25 281.75 313.25 282.25 233.25 340.00 290.50 280.50 313.50 292.25 251.75 317.00 293.50 324.00 266.50 337.00 277.00 269.25 239.75 267.75 231.00 335.00 296.75 267.25 275.25 263.50 280.75 330.00 32 264.00 311.50 298.75 348.25 272.25 326.75 271.75 315.00 289.75 319.75 306.00 277.00 281.50 303.75 265.50 319.25 293.75 337.25 294.25 267.75 272.50 285.75 223.50 322.25 305.50 298.50 301.75 244.25 280.00 341.75 33 278.00 355.50 332.75 284.75 305.50 309.00 251.25 328.75 296.75 281.25 314.50 299.75 241.00 331.00 275.75 237.00 308.00 326.75 284.00 270.25 301.25 283.25 264.00 309.75 303.75 278.00 295.75 242.25 264.25 329.50 34 289.75 327.00 284.75 303.50 300.25 292.00 267.00 327.25 255.25 311.50 300.75 273.25 281.00 268.25 294.50 291.00 258.75 327.00 328.25 235.00 249.25 263.00 253.00 310.50 308.00 340.25 338.00 260.75 262.50 306.50 35 293.00 339.00 351.75 299.50 282.50 288.50 258.50 313.75 286.25 289.75 310.50 279.75 264.00 290.75 288.00 266.75 312.50 304.75 261.25 279.25 249.75 268.25 195.75 309.25 319.00 330.25 288.00 255.75 279.75 334.50 36 277.75 319.25 279.00 314.00 270.50 296.00 227.25 320.75 271.75 327.00 293.50 300.25 266.00 280.75 256.00 315.75 335.25 328.25 282.25 225.75 265.25 254.00 246.75 290.75 306.25 298.25 324.00 264.75 229.75 309.00 37 292.25 327.50 307.25 307.50 288.75 280.00 257.25 311.75 242.50 283.25 273.00 292.00 288.75 249.00 242.50 261.25 304.00 354.75 278.75 265.25 223.25 279.75 209.25 306.75 308.00 318.75 304.50 244.50 246.25 338.25 38 290.00 302.50 277.00 290.75 301.00 331.75 282.50 335.00 256.75 292.00 287.75 277.25 267.25 267.00 265.75 277.00 318.25 335.25 274.25 244.00 240.75 268.00 218.00 311.25 326.50 304.25 337.00 252.75 252.25 331.75 39 288.75 328.00 253.00 300.25 270.50 290.50 272.75 322.25 289.50 307.50 317.75 291.25 234.25 294.75 270.50 299.25 263.25 351.50 279.75 272.75 255.75 285.00 272.50 294.50 357.25 309.25 310.00 254.25 248.50 340.50 40 303.00 330.50 304.00 325.25 289.00 328.50 243.75 340.00 274.75 305.25 311.50 310.25 259.25 309.50 308.25 291.50 337.00 341.50 300.00 280.00 283.75 269.50 234.50 315.75 317.25 276.00 299.50 250.50 246.00 346.75 41 287.25 312.75 289.00 326.00 291.50 307.50 235.00 316.75 267.50 334.25 302.50 306.75 292.00 252.00 276.25 322.75 285.00 344.50 291.25 223.50 211.50 296.75 234.75 309.75 320.75 282.50 316.50 260.50 231.50 336.00 42 289.00 316.50 317.25 286.00 275.50 278.25 278.50 302.75 308.25 301.50 301.25 310.00 258.00 285.25 295.50 329.75 325.75 329.75 298.50 279.25 236.75 269.50 232.50 335.00 321.00 274.50 282.50 255.75 239.00 316.25 43 307.00 371.75 301.25 313.00 307.00 277.75 238.75 283.00 260.00 266.75 284.00 300.75 225.00 257.50 272.75 263.75 301.00 350.00 245.25 242.25 207.25 271.75 197.50 282.50 301.00 269.50 311.00 230.25 283.25 316.25 44 287.00 320.50 280.00 319.50 291.50 310.50 238.75 310.25 294.25 291.00 287.25 285.00 244.00 268.25 264.00 273.75 314.00 321.25 296.00 232.50 268.50 272.50 212.75 327.75 342.00 307.00 303.00 253.00 271.00 332.00 45 307.00 317.00 340.25 324.75 278.50 271.00 259.25 332.50 300.50 300.75 332.25 274.75 260.50 311.25 290.00 294.00 341.75 317.25 299.25 237.00 230.25 284.25 225.75 294.50 304.00 280.50 350.50 255.75 240.00 304.25 46 309.00 328.50 263.25 303.00 302.25 265.50 239.75 341.50 280.75 295.75 287.25 275.00 252.50 315.50 278.25 289.25 314.50 328.75 247.00 259.50 238.25 263.00 212.75 317.50 326.75 334.75 304.75 236.75 287.25 349.00 47 289.86 328.59 301.64 308.08 289.75 295.10 251.90 321.90 279.50 297.98 299.99 293.19 260.29 285.79 278.69 289.90 305.91 335.66 283.68 258.88 251.70 273.36 224.39 312.38 317.51 295.71 312.69 250.44 259.90 331.45 <tbody> </tbody>

<tbody>
</tbody>

 

[aqeelnokia99]

i can not understand your data and what uResult can u plz upload your excel sheet data and result that u want in excel file some whre so i download it i try to make a formula for u

 

[AhoyNC]

Try:
For the count of Proj 1U

'=SUMPRODUCT(($B$1:$AE$1=3)*($B$4:$AE$24>=300))

For the count of Proj 2U

=SUMPRODUCT(($B$1:$AE$1=3)*($B$27:$AE$47>=300))

 

[aqeelnokia99]

Try this
=SUMPRODUCT(--((CHOOSE(RIGHT(A2,1),$B$8:$AE$28,$B$30:$AE$50))*(A3=$B$5:$AE$5)>=300))

 

[GParis]

Thank you AhoyNC, that works perfectly.

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.