Counting
 

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

Counting
 

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

regards
FSt1

"cjay510" wrote:

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

Counting
 

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.

"FSt1" wrote:

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

regards
FSt1

"cjay510" wrote:

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