Find a specific text in one column and then count specific values in another column

spothier1

Hello,

I am looking to do two reports:

For Over - I want to know how many 1's, 2s, 3s, Agreement in Place

And the same for under

So would it be a vlookup to find "over" and then count the 1s? Or a Countifs statement to find Over and then count the #s

sharkasits

@spothier1 If I understand correctly, you're looking for a formula to get 8 different results. Count of

1. over & 1
2. over & 2
3. over & 3
4. over & Agreement in Place
5. under & 1
6. under & 2
7. under & 3
8. under & Agreement in Place

If that's the case I would set up a table with Column A = Over or Under, Column B = Risk Level, Column C = formula below for counts:

=COUNTIFS([Over/Under Threshold]:[Over/Under Threshold], [Column A]@row, [Risk Level]:[Risk Level], [Column B]@row)

sharkasits

@spothier1 If I understand correctly, you're looking for a formula to get 8 different results. Count of

1. over & 1
2. over & 2
3. over & 3
4. over & Agreement in Place
5. under & 1
6. under & 2
7. under & 3
8. under & Agreement in Place

If that's the case I would set up a table with Column A = Over or Under, Column B = Risk Level, Column C = formula below for counts:

=COUNTIFS([Over/Under Threshold]:[Over/Under Threshold], [Column A]@row, [Risk Level]:[Risk Level], [Column B]@row)

spothier1

oh that worked perfect!!!!!!!! thank you!!!