Question on CountIfs

[Leigh Digons]

I want to count promotions in certain categories if multiple criteria are met, but NOT count if one cell equals Staff and one cell equals Senior Staff because that is not considered a promotion officially, however since the text is different in the cell it is picking it up as a promotion.

I have attached a mock file, and cannot figure out how to get the counts right.

 

[Nebu]

Hi:

Hope this is what you are looking for....
I have constructed the formula is yellow cells , you can replicate it for the other cells.

Thanks

 

[Leigh Digons]

Hi there, is this a formula I can copy and paste into the other cells? I would like there to be a record of a transfer if it goes from Staff or Senior Staff to Manager or vice versa as well.

 

[Nebu]

Hi:
You can copy this formula across , change the range as per your need.

Note:

This is an array formula execute it by pressing control+shift+enter.

I did not get the part ,"I would like there to be a record of a transfer if it goes from Staff or Senior Staff to Manager or vice versa as well."

Could you explain it a bit more or can can upload a file with expected results.

Thanks