Countifs multiple text in a row

edited 08/22/24

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

• ✭✭✭

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?

• ✭✭✭

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?

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!