COUNTIFS including OR

Mickes

New Member
Joined
Sep 22, 2014
Messages
4
Hi,

Trying to create this formula... but there seems to be some error. Cant seem to figure out how to combine COUNTIFS with OR

=COUNTIFS('In Native source'!$A:$A,$A4,'In Native source'!K:K,"no")+OR('In Native source'!J:J,"a",'In Native source'!J:J,"b",'In Native source'!J:J,"c")

So the first two criteria are obligatory, bot have to be, and then it can be either of the three following.

Thanks for any assistance!
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,393
Try

=SUM(COUNTIFS('In Native source'!$A:$A,$A4,'In Native source'!K:K,"no",'In Native source'!J:J,{"a";"b";"c"}))

Hope this helps

M.
 

Steph77

Board Regular
Joined
Sep 18, 2014
Messages
119
Try this:

=COUNTIFS('In Native source'!$A:$A,$A4,'In Native source'!K:K,"no",'In Native source'!J:J,"a")+COUNTIFS('In Native source'!$A:$A,$A4,'In Native source'!K:K,"no",'In Native source'!J:J,"b")+COUNTIFS('In Native source'!$A:$A,$A4,'In Native source'!K:K,"no",'In Native source'!J:J,"c")
 

Watch MrExcel Video

Forum statistics

Threads
1,109,523
Messages
5,529,334
Members
409,863
Latest member
stacy09
Top