# Countifs Multiple Criteria Met

#### GParis

##### New Member
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>

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
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

Try:
For the count of Proj 1U
Code:
``'=SUMPRODUCT((\$B\$1:\$AE\$1=3)*(\$B\$4:\$AE\$24>=300))``

For the count of Proj 2U
Code:
``=SUMPRODUCT((\$B\$1:\$AE\$1=3)*(\$B\$27:\$AE\$47>=300))``

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

Thank you AhoyNC, that works perfectly.

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

1,203,672
Messages
6,056,670
Members
444,881
Latest member
Stu2407

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back