Count with multiple criterias (one or the other criteria)

Tony Oxa

Hi all,

I am trying to count based on two criterias (if it's one or the other, they don't need to be both meet)

Thank you.

Paul Newcome

Do the two different criteria exist within the same range or is it two separate ranges as well?

Tony Oxa

they are in the same column

Paul Newcome

Then you would need something like this:

=COUNTIFS({Range}, OR(@cell = "this", @cell = "that"))

Tony Oxa

Hi Paul,

I tried this before and it says invalid operation. I have a survey with the answers and i want to count how many have answered "Strongly Disagree" and "Disagree". The answers ("Strongly Disagree", "Disagree) are in the same column in another sheet.

Best,

Tony

Paul Newcome

Can you copy/paste the exact formula that is throwing the error from the sheet to here?