Countifs except when two columns read "x"

[xenomorph8472]

Hello!

I'm trying to find total gross commission within a spreadsheet, where gross commission found in Deals column Q. Columns T & U indicate with an "X" whether the deal was associated with referrals and such.

=SUMIFS(Deals!$Q$2:$Q$500, Deals!$T$2:$T$500, "x",Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<1/1/2006")

=SUMIFS(Deals!$Q$2:$Q$500, Deals!$U$2:$U$500, "x",Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<1/1/2006")

But now I need to sumif Q2:Q500 excluding rows where "X appears in either T or U, or both, to indicated complete self-generated deals.

Any help would be greatly appreciated!

[Kevin UK]

Hi xenomorph8472

SUMIFS will not do or criteria you will need to use SUMPRODUCT.

[Ace_XL]

Try

Please Login or Register  to view this content.

[xenomorph8472]

Thanks so much Ace...works perfectly. I really appreciate your help!