Count formula - or not?



I have 20 columns that have a drop down list with three items that one must select "NO", "On-Site" and "Virtual". I need to be able to have two calculations come from those 20 columns for each row. The first calculation i need is "How many were either On-Site or Virtual (or how many were not "No") and the second calculation needs to be How many were "Virtual" . it's complicated as it will involve at least 20 cells in the row but i can't figure out how to do the formula to get the information i need. The sheet as about 100 rows that this will apply to.

thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!