Countifs multiple text in a row

Brandon Kennedy

I am trying to count "YES and "N/A" in the same row in 11 I can get the =COUNTIFS([Pole Spotted ]@row:CLIPPED@row,"YES", to work Fine but I also need it to count the N/A I know this is probably simple but I am lost

DavidMMM

You just need 2 COUNTIF (no S) and add them together.

=countif([Pole Spotted ]@row:CLIPPED@row, "Yes") + countif([Pole Spotted ]@row:CLIPPED@row, "N/A")

COUNTIFS with the S works if you are collecting multiple criteria across multiple ranges. It wouldn't work here because it would look to validate both Yes and N/A in the same cell which clearly does not work.

Does this work out for you now?

DavidMMM

You just need 2 COUNTIF (no S) and add them together.

=countif([Pole Spotted ]@row:CLIPPED@row, "Yes") + countif([Pole Spotted ]@row:CLIPPED@row, "N/A")

COUNTIFS with the S works if you are collecting multiple criteria across multiple ranges. It wouldn't work here because it would look to validate both Yes and N/A in the same cell which clearly does not work.

Does this work out for you now?

Andrée Starå

https://community.smartsheet.com/discussion/129714/countifs-multiple-text-in-a-row

Hi,

I hope you're well and safe!

Try something like this.

=COUNTIF([Pole Spotted]@row:CLIPPED@row, OR(@cell = "YES", @cell = "N/A"))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Brandon Kennedy

thank you guys Andree I tried your statement but came back not working .

Murau that fixed it thank you for the prompt response thank you again guys