Calculating %Yes answers for each month on a spreadsheet (grid) with yearly data
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

You would start by using a COUNTIFS to determine how many yes answers are in a single month and then divide that by a COUNTIFS that counts the total number of entries for the same month.
Answers

You would start by using a COUNTIFS to determine how many yes answers are in a single month and then divide that by a COUNTIFS that counts the total number of entries for the same month.

Can you do a COUNTIFS formula to get your numerator (times 'Yes' was marked) and another COUNTIFS formula to get your denominator (times the field is not blank)?
Something like this:
=COUNTIFS(Month7:Month12, "January", [Status1]7:[Status1]12, "Yes") / COUNTIFS(Month7:Month12, "January", [Status1]7:[Status1]12, <>"")
I'm not sure what your columns are and I wouldn't use static cell references, but you get the picture. The assumption is that you want to count the rows with Yes or No values only.

Thanks both. Works well.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!