Formula using OR

Shannon Lacerda

Can someone help me I keep getting a error message, I know is has to be the OR function.

=COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", OR({Civic 2021 Range 4}, "(Stage 3) 3.2 - WON", {Civic 2021 Range 4}, "(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)

Kelly Moore

Hey @Shannon Lacerda

Try this

=COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", {Civic 2021 Range 4}, OR(@cell="(Stage 3) 3.2 - WON", @cell="(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)

cheers,

Kelly

Kelly Moore

Hey @Shannon Lacerda

Try this

=COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", {Civic 2021 Range 4}, OR(@cell="(Stage 3) 3.2 - WON", @cell="(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)

cheers,

Kelly

Shannon Lacerda

Thank you so much that worked!!!!

Virtual HIGH FIVE!🖐️

Kelly Moore

🖐

Shannon Lacerda

How many logics can you use an in an OR function, I tried to add a 3 and it wont work

The bold is the new part.

=COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", {Civic 2021 Range 4}, OR(@cell = "(Stage 3) 3.2 - WON", @cell = "(Stage 3) 3.3 - LOST", @cell = "(Stage 3) 3.1 - RFP Submitted"), {Civic 2021 Range 1}, "Pursuit Plan Completed", {Civic 2021 Range 3}, MONTH(@cell) = 1)

Shannon Lacerda

Nevermind it worked, it was my error in not filling the cell !!!