Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula should I use?
Hi,
I need a bit of guidance as to which formula i could use to perform the following sum: I have a recruitment table that details how many positions are presently opened or closed for multiple business units. I want to determine for every business unit how many of the positions are open. I have been looking at different functions but have been unable to determine the correct one. Please Help!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula should I use?
hi, 'anonymous' !
have a look at this one: Multiple Condition Tests: - http://www.xldynamic.com/source/xld.SUMPRODUCT.html hth, hector. __ OP __ I need a bit of guidance as to which formula i could use to perform the following sum: I have a recruitment table that details how many positions are presently opened or closed for multiple business units. I want to determine for every business unit how many of the positions are open. I have been looking at different functions but have been unable to determine the correct one. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula should I use?
Hi Hector,
Thanks very much!! Not sure why I came up as an anonymous user?! Jenny. "Héctor Miguel" wrote: hi, 'anonymous' ! have a look at this one: Multiple Condition Tests: - http://www.xldynamic.com/source/xld.SUMPRODUCT.html hth, hector. __ OP __ I need a bit of guidance as to which formula i could use to perform the following sum: I have a recruitment table that details how many positions are presently opened or closed for multiple business units. I want to determine for every business unit how many of the positions are open. I have been looking at different functions but have been unable to determine the correct one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|