Using COUNTIFS with multiple criteria-need help!

SteveDCYF

Hi everyone, I am trying pull a count that has the following information on my sheet

-"other" in the Focus Area Column

-"Disagree" in the Resources 1, 2 or 3 columns

-"Strongly Disagree" in the Resources 1,2 or 3 columns

I have the formula below, but it's giving me the "Incorrect Argument Set" error

Can someone help me sort this out please, thank you!

=COUNTIFS({DCYF OneWA Pulse-checks Range 1}, Answers@row, {DCYF OneWA Pulse-checks Range 11}, "Disagree", {DCYF OneWA Pulse-checks Range 11,"Strongly Disagree"})

Nic Larsen

Looks like a bracket is out of place - try:

=COUNTIFS({DCYF OneWA Pulse-checks Range 1}, Answers@row, {DCYF OneWA Pulse-checks Range 11}, "Disagree", {DCYF OneWA Pulse-checks Range 11},"Strongly Disagree")

But I'll add, if the range is covering all three columns, I can't recall if a Countif can do that or not. You may need to make a new range for each column.