Find a specific text in one column and then count specific values in another column
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
Best Answer

@spothier1 If I understand correctly, you're looking for a formula to get 8 different results. Count of
 over & 1
 over & 2
 over & 3
 over & Agreement in Place
 under & 1
 under & 2
 under & 3
 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)
Answers

@spothier1 If I understand correctly, you're looking for a formula to get 8 different results. Count of
 over & 1
 over & 2
 over & 3
 over & Agreement in Place
 under & 1
 under & 2
 under & 3
 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)

oh that worked perfect!!!!!!!! thank you!!!
Help Article Resources
Categories
Check out the Formula Handbook template!