Using 'OR' Function within 'COUNTIFS'

Josh S

Hi, I am having trouble with a formula.

I am trying to count the number of items with a Status of "1.6 QUOTE SENT" AND "2.1 DRAFT", but I'm unable to get the formula to function. I'm having trouble correctly parsing the OR function in the formula:

=COUNTIFS({3. LIVE ORDERS Status}, OR("1.6 QUOTE SENT", "2.1 DRAFT"), {3. LIVE ORDERS Quote Sent}, DATE@row)

The formula works correctly when I am not using the OR status

=COUNTIFS({3. LIVE ORDERS Status}, "1.6 QUOTE SENT", {3. LIVE ORDERS Quote Sent}, DATE@row)

Any help would be greatly appreciated.

Thanks!

Lucas Rayala

https://community.smartsheet.com/discussion/116326/using-or-function-within-countifs

hey Josh, I think this just needs a slight adjustment:

OR(@cell=“value 1”, @cell =“value 2”)

alternately, you could always just add the output of two COUNTIFS like this:

=COUNTIFS(<criteria 1>) + COUNTIFS(<criteria 2>)

Anjanesh Vaidya

Hi Josh S,

You can try the below formula:

=COUNTIFS({3. LIVE ORDERS Status}, "1.6 QUOTE SENT") + COUNTIFS({3. LIVE ORDERS Status}, "2.1 DRAFT", {3. LIVE ORDERS Quote Sent}, DATE@row)

I hope it will work, if not, can you please provide the screenshot for context? (Removing any sensitive information)

Thank you!

Anjanesh Vaidya