Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting 2 Separate Columns With Unique Data
I WONDER IF THIS COULD BE DONE IN VBA
I wish to count how many people we pay as full time, part time or temporary staff. This requires the formula to look in one column for where type is FT and in another column for where salary is 0. When these conditions are met, it should count how many cells in the salary row have a salary figure and that will be our headcount for that period. A sample data is below: A Staff name BType C Salary Ken FT 3500 Toni FT 3500 Del PT 2980 Dave FT 0 The above should return 2 for full time headcount because Dave is no longer with the company. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting 2 Separate Columns With Unique Data
=Sumproduct(($B$1:$B$500="FT")*($C$1:$C$5000))
will give you the count. -- Regards, Tom Ogilvy "JAYDE" wrote in message ... I WONDER IF THIS COULD BE DONE IN VBA I wish to count how many people we pay as full time, part time or temporary staff. This requires the formula to look in one column for where type is FT and in another column for where salary is 0. When these conditions are met, it should count how many cells in the salary row have a salary figure and that will be our headcount for that period. A sample data is below: A Staff name BType C Salary Ken FT 3500 Toni FT 3500 Del PT 2980 Dave FT 0 The above should return 2 for full time headcount because Dave is no longer with the company. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting with multiple criteria in separate Columns | Excel Discussion (Misc queries) | |||
Counting Unique Values That Are Separate by Commas in a Column | Excel Discussion (Misc queries) | |||
Counting unique combinations in two columns | Excel Discussion (Misc queries) | |||
Counting based on values in two separate columns | Excel Worksheet Functions | |||
Counting values for variables in separate columns | Excel Discussion (Misc queries) |