Counting

C

cjay510

I'm trying to count the number of jobs that produced bolts which are greater
than 7mm's in size. I'm having trouble because of the multiple entries for
each job.

ex:
Job # Size (mm's)
1 6
1 7
1 8
2 7
2 8
2 9
2 10
3 5
3 6
3 7
 
F

FSt1

hi
try this...
assuming data in columns A and B....
=countif(B2:B11,">6")

regards
FSt1
 
C

cjay510

I've tried your suggestion the only problem is that each job is counted
multiple times instead of just once. For example in job 2 below the formula
results in a count of 3 because the job produced sizes 8, 9, and 10. I only
need the job counted once because it yielded sizes greater than 7. Hope I'm
making a little more sense.
 
Top