I don't know if I need to upload an example... this is pretty vanilla.

Column M= profit
Column F= salesman 1
Column G= salesman 2
Column E= N for new or U for used
Cell AA4 + salesman

I want to pull the sum of profit in column M if AA4 matches EITHER column F OR column G AND N in Column E.

I could do this using 3 columns with straight up sumifs for each salesman position, then totaling... but I have multiple columns to do this for, and I'm wondering how I might incorporate the OR function within a regular SUMIFS string.

here's the formula I need to improve:
=SUMIFS(DEALS!M9:M408,DEALS!E9:E408,"N",DEALS!F9:F408,AA4)