Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting items in one column based on criteria in another
I'm trying to count the number of rows in a column which meet criteria
identified in another column. I'm creating a payroll template where one column identifies whether the position is full-time or part-time. In my first month of payroll I want to be able to count the number payroll amounts which are classified as full-time. I also want to ignore any zeroes. Any help would be greatly appreciated. In using Windows 2003 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting items in one column based on criteria in another
*Maybe* this....
=SUMPRODUCT(--(A1:A100="full-time"),--(B1:B1000)) -- Biff Microsoft Excel MVP "kmc103" wrote in message ... I'm trying to count the number of rows in a column which meet criteria identified in another column. I'm creating a payroll template where one column identifies whether the position is full-time or part-time. In my first month of payroll I want to be able to count the number payroll amounts which are classified as full-time. I also want to ignore any zeroes. Any help would be greatly appreciated. In using Windows 2003 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting items in one column based on criteria in another
Unfortunately that didn't work. I tried the formula and it gave me a zero
value. Also, I'm looking to count the # of cells which match the criteria. I think sumproduct would give me the sum. Thanks - I appreciate the response "T. Valko" wrote: *Maybe* this.... =SUMPRODUCT(--(A1:A100="full-time"),--(B1:B1000)) -- Biff Microsoft Excel MVP "kmc103" wrote in message ... I'm trying to count the number of rows in a column which meet criteria identified in another column. I'm creating a payroll template where one column identifies whether the position is full-time or part-time. In my first month of payroll I want to be able to count the number payroll amounts which are classified as full-time. I also want to ignore any zeroes. Any help would be greatly appreciated. In using Windows 2003 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting items in one column based on criteria in another
If that formula gave a zero result it means that you have no rows in which
column A ="full-time" and column B0. If you have any rows which meet both those criteria, that formula will count them. -- David Biddulph "kmc103" wrote in message ... Unfortunately that didn't work. I tried the formula and it gave me a zero value. Also, I'm looking to count the # of cells which match the criteria. I think sumproduct would give me the sum. Thanks - I appreciate the response "T. Valko" wrote: *Maybe* this.... =SUMPRODUCT(--(A1:A100="full-time"),--(B1:B1000)) -- Biff Microsoft Excel MVP "kmc103" wrote in message ... I'm trying to count the number of rows in a column which meet criteria identified in another column. I'm creating a payroll template where one column identifies whether the position is full-time or part-time. In my first month of payroll I want to be able to count the number payroll amounts which are classified as full-time. I also want to ignore any zeroes. Any help would be greatly appreciated. In using Windows 2003 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting items in one column based on criteria in another
It does work - I was missing the dashes in the formula. Thanks to both of
you for your help! "David Biddulph" wrote: If that formula gave a zero result it means that you have no rows in which column A ="full-time" and column B0. If you have any rows which meet both those criteria, that formula will count them. -- David Biddulph "kmc103" wrote in message ... Unfortunately that didn't work. I tried the formula and it gave me a zero value. Also, I'm looking to count the # of cells which match the criteria. I think sumproduct would give me the sum. Thanks - I appreciate the response "T. Valko" wrote: *Maybe* this.... =SUMPRODUCT(--(A1:A100="full-time"),--(B1:B1000)) -- Biff Microsoft Excel MVP "kmc103" wrote in message ... I'm trying to count the number of rows in a column which meet criteria identified in another column. I'm creating a payroll template where one column identifies whether the position is full-time or part-time. In my first month of payroll I want to be able to count the number payroll amounts which are classified as full-time. I also want to ignore any zeroes. Any help would be greatly appreciated. In using Windows 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Items with Multiple Criteria | Excel Worksheet Functions | |||
Counting Unique Items with Multiple Criteria | Excel Worksheet Functions | |||
Counting Unique Items with Multiple Criteria | Excel Worksheet Functions | |||
sum items in a column based on criteria located in other columns | Excel Discussion (Misc queries) | |||
Counting & Summing based on criteria on another column | Excel Discussion (Misc queries) |