COUNTIFS and OR statement together?

Jessica Abbey

I have several countifs together and I need to add another set ("Status" column that states "not started" or "in progress"). Everything I've tried has not worked.

=COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, "not started OR "in progress")

Sam M.

Hi Jessica,

I did a little testing:

 

This is what I used:

=COUNTIFS([Column2]1:[Column2]7, "assistance needed", Status1:Status7, OR(@cell = "not started", @cell = "in progress"))

 

What worked for me was adding this in the criteria for status:

OR(@cell = "not started", @cell = "in progress")

 

Which in your case might be:

=COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, OR(@cell = "not started", @cell = "in progress"))

 

Hope it helps,

Samantha

Leibel S

@Jessica Abbey

See below proper syntax:

=COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, or(@cell="not started", @cell="in progress"))

Sam M.

Hi Jessica,

I did a little testing:

 

This is what I used:

=COUNTIFS([Column2]1:[Column2]7, "assistance needed", Status1:Status7, OR(@cell = "not started", @cell = "in progress"))

 

What worked for me was adding this in the criteria for status:

OR(@cell = "not started", @cell = "in progress")

 

Which in your case might be:

=COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, OR(@cell = "not started", @cell = "in progress"))

 

Hope it helps,

Samantha

Jessica Abbey

This did the trick! THANK YOU! working in formulas all morning my brain just could not get this syntax correct.