NEW DEAL LOG 4-23-13.xlsx

is there a variation of countifs that will work this way?

I now need to count units based on multiple conditions for salesman if they are in either column.

ex: on the STAFF sheet, I figured a way of getting how many cash deals a salesman has, but it took me 5 columns to come up with it.

I need to look at the deals sheet, and count how many of X for a salesman, whether he is first or second... the wrinkle comes because when there ARE 2 salesmen, I need to give them half of the unit... so I have to isolate how many split deals they had that are X also... and then subtract it form the raw count.

thx
j