Counting

  • Thread starter Thread starter cjay510
  • Start date Start date
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
 
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.
 
Back
Top