Need some help with a COUNTIFS statement looking for one OR another

sheila8492

Hello

I'm trying to figure out how to use an "or" with a COUNTIFS statement. This formula is looking at the “Amendment” column for “2018” contracts, and I want to return how many in the amendments column have a value of X or Y. It works for X, but I don’t know how to add the “or Y” to it. Here's what is there so far: =COUNTIFS({PWB Contracts 2018 - Amendment}, "X", {PWB Contracts 2018 - Fiscal Year}, "2018")

Thank you,

Sheila

Leibel S

@sheila8492

=COUNTIFS({PWB Contracts 2018 - Amendment}, OR(@ ), {PWB Contracts 2018 - Fiscal Year}, "2018")

sheila8492

I appreciate the help but I can't seem to make it work.

=SUMIFS({PWB Contracts 2018 -Contract Total}, {PWB Contracts 2018 - Amendment}, OR("X", {PWB Contracts 2018 - Amendment}, "Y"), {PWB Contracts 2018 - Fiscal Year}, "2018")

In the amendments column, I want it to look for "X" or "Y".

Thank you.

Courtney S.

Hi! The X and Y can both be inside the OR function as the item you're looking for in the amendment range. Try this, I think this is what Leibel meant to type:

=COUNTIFS({PWB Contracts 2018 - Amendment}, OR(@cell = "X", @cell = "Y"), {PWB Contracts 2018 - Fiscal Year}, "2018")

OR function page:

OR Function | Smartsheet Learning Center

sheila8492

Well shoot! I could not get it to compute, but I found a work-around with two helper cells and then added those together. I'm going to have to learn more about formulas.

Thank you both for trying to help.

Sheila

Michelle Choate 2

@sheila8492 Can you share what you did?