COUNTIFS with OR

[megera716]

Here's my formula right now:
=COUNTIFS(Q$2:Q$1127,$B1136,F$2:F$1127,"Y",$A$2:$A$1127,"Provider")

I want to COUNTIF $A$2:$A$1127 contains "Vendor" OR "Investor" along with the conditions for ranges in Q and F.

I tried =COUNTIFS(Q$2:Q$1127,$B1140,D$2:D$1127,"Y",OR($A$2:$A$1127="Vendor",$A$2:$A$1127="Investor")), but that left me with Excel thinking the whole OR function was only my criteria range so that didn't work.


Edited to add, then I need to do the same thing with SUMIFS. Right now, looks like =SUMIFS(R$2:R$1127,Q$2:Q$1127,$B1136,F$2:F$1127,"Y",$A$2:$A$1127,"Provider")

 

[Joe4]

Try:

[COLOR=#333333]=COUNTIFS(Q$2:Q$1127,$B1136,F$2:F$1127,"Y",$A$2:$A$1127,"Provider") + [/COLOR][COLOR=#333333]COUNTIFS(Q$2:Q$1127,$B1136,F$2:F$1127,"Y",$A$2:$A$1127,"Investor")[/COLOR]

 

[megera716]

D'oh, of course!! I should have known that. Thanks! (I assume the same thing will work for the SUMIFS).

 

[Joe4]

Thanks! (I assume the same thing will work for the SUMIFS).

You are welcome.
Yes, the same logic should work for SUMIFS.

 

[DanteAmor]

It can also be:

=SUM(COUNTIFS(Q$2:Q$1127,$B1136,F$2:F$1127,"Y",$A$2:$A$1127,{"Provider","Investor"}))