Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting | Excel Discussion (Misc queries) | |||
Counting | Excel Discussion (Misc queries) | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |