Formula Correction Needed

Options

Hello,

Can you please assist in fixing the formula below to count the cells in the column that are either "Y" or "N/A"? The formula I have currently works but only accounts for "Y".

=COUNTIF({Column1}, "Y") / COUNT({Column1})

Arielle Priday, Project Administrator

Prism Professional Services Group

4340 W. Chandler Blvd | Ste 8 | Chandler, AZ 85226

tel (480) 712-3500 | website | map | email | AZ ROC 327159

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!