COMBINING COUNTIFS with AND, for multiple Columns! Help!

SteveDCYF

SteveDCYF

Can someone please help with the formula, I have this but I keep getting errors! Thank you in advance

=COUNTIFS({DCYF OneWA Pulse-checks Range 11}, Answers@row, {DCYF OneWA Pulse-checks Range 11}, @cell = "disagree", @cell = "strongly disagree")

heyjay

=COUNTIFS(
{DCYF OneWA Pulse-checks Range 11}, Answers@row, 
{DCYF OneWA Pulse-checks Range 11},"disagree",
{DCYF OneWA Pulse-checks Range 11},"strongly disagree")

You can go thru this route.

SteveDCYF

Hi @heyjay thank you for the formula, but I received a 0 as a result where the result should be at least 1 given the count of disagree in the "other" row. Here is the formula I am using.

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

heyjay

Please change your name ranges, all range says RANGE 11. What columns does Disagree, Stongly Disagree, and Answers@row falls?

SteveDCYF

There are two columns I would like to get information from. The program awareness 1 and program awareness 2.

heyjay

With your given formula, replace the name ranges.

=COUNTIFS(
[DCYF Focus area]:[DCYF Focus area], Answers@row,
[program awareness 1]:[program awareness 1], "Disagree",
[program awareness 1]:[program awareness 1], "Strongly Disagree")

looks like I dont know what I am doing here, if this does not work, I will give it another check

SteveDCYF

Thank you for trying but I keep getting errors. Basically I would like to return the count for any Disagree or Strongly Disagree for Program awareness 1 and program awareness 2 for the choices in the Focus area column like other, payroll, etc.