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
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
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.
Agree a sample WB will help, but try using countifS() function, instead of just countif()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Countifs does not support the OR() function, you can use SUMPRODUCT:
=SUMPRODUCT((D2:D10=0)*(E2:E10="AR")*ISNUMBER(SEARCH("/",L2:L10&M2:M10)))
OP didn't have the expected result, so I can't test it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks