Hello, Ive got a spreadsheet with around 100 columns in it. but i need a formula for 2 columns. one column has a number 1,2,3,4, or 5 in it. the other column has different numbers it.

I'm wanting to have a formula that looks at the first column (with 1,2,3,4, or 5 in it. For example it it sees "1" in the first column & will count the amount of numbers in the other column that are under 10. Does that make sense? For example:

1 100
1 5
3 50
1 8
4 60
5 2

So i would need it to return the number "2"

Thanks