# COUNTIFS including OR

#### Mickes

##### New Member
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!

### Excel Facts

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

#### Marcelo Branco

##### MrExcel MVP
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
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")

#### Mickes

##### New Member
Ok Great!! thanks a lot! Both works.

Replies
11
Views
236
Replies
24
Views
1K
Replies
0
Views
66
Replies
3
Views
35
Replies
7
Views
129