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.