Counting

[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

 

[FSt1]

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

regards
FSt1

 

[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.