Euro5
asked on
Using OR in a COUNTIFS statement
=COUNTIFS(Static!A2:A78438 ,OR(120,12 1),Static! B2:B78438, "NO PRICING")
This is returning 0 when there are over 1000.
Any ideas what could be wrong?
I want to count how many say NO PRICING in column B when there are either 120 or 121 in column A.
Thanks!
This is returning 0 when there are over 1000.
Any ideas what could be wrong?
I want to count how many say NO PRICING in column B when there are either 120 or 121 in column A.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This will also work: allows for numbers between a range not just 120-121
=COUNTIFS(Static!B2:B78438 ,"NO PRICING",Static!A2:A78438, ">=120",St atic!A2:A7 8438,"<=12 1")
=COUNTIFS(Static!B2:B78438
ASKER
Thanks so much!! Perfect!
=COUNTIFS(Static!A2:A78438
Being the easy solution