Calculating %Yes answers for each month on a spreadsheet (grid) with yearly data

Vinton Douglas
Vinton Douglas ✭✭✭
edited 06/20/22 in Formulas and Functions

I have a spreadsheet (grid) populated with "yes" and "no" based on the answers provided. This sheet has multiple data for the entire year i.e January to December. I need a formula to calculate the %yes for each month on the spreadsheet containing the yearly data.


Any help would be appreciated.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!