What formula should I use?

[Excel User]

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!!!

 

[Héctor Miguel]

hi, 'anonymous' !

have a look at this one: Multiple Condition Tests:
-> http://www.xldynamic.com/source/xld.SUMPRODUCT.html

hth,
hector.

__ OP __

 

[Excel User]

Hi Hector,

Thanks very much!! Not sure why I came up as an anonymous user?!

Jenny.