count formula

J

Jerie

How can I count a number of rows in column B that has a
value
of less than 85
A B C
1 12
1 7
1 15
1 20
1 105 4
2 7
2 12
2 36
2 90 3
3 15
3 25
3 100 2

Where A=Reference
B=Values
C=Results

Your help is very much appriciated, Thank You

Rgd Jerie
 
Top