Combining CountIf with an OR function

[Boheret5an]

Hello
excel.png
i want a formula to count if D column = 0 and E column=AR and if L or M column have "/" sign in them.

thanks in advance

[CARACALLA]

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[FDibbins]

Agree a sample WB will help, but try using countifS() function, instead of just countif()

[Phuocam]

Countifs does not support the OR() function, you can use SUMPRODUCT:

=SUMPRODUCT((D2:D10=0)*(E2:E10="AR")*ISNUMBER(SEARCH("/",L2:L10&M2:M10)))

[FDibbins]

Countifs does not support the OR() function, you can use SUMPRODUCT:

=SUMPRODUCT((D2:D10=0)*(E2:E10="AR")*ISNUMBER(SEARCH("/",L2:L10&M2:M10)))

Agreeed, but I figured 1 or the other would have 1 so count them both.

[Phuocam]

OP didn't have the expected result, so I can't test it.

[bebo021999]

Agreeed, but I figured 1 or the other would have 1 so count them both.

I believe ISNUMBER(SEARCH("/",L2:L10&M2:M10)) count 1 if there was at least one "/" in both columns.