# 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

• ✭✭✭✭

@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 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)
```
• oh that worked perfect!!!!!!!! thank you!!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!