Exclude filtered out data in a sheet summary report
I have a filter in my sheet that uses Y or N in order to exclude the rows not used in each particular project. I am building a sheet summary report and would like to include only the data that has "Y" in the row and exclude data that has a "N" in the row. Can I put a formula in a sheet summary report? If so, I need help writing it.
Additionally, the current formula (=COUNTIF(Health:Health...)in the sheet summary report provides a count of complete, medium risk, high risk, etc. If I am able to remove the rows above from the data, I will need to change the formula to a percent so it is only based on the what is included in the data. How do change a count formula to a % formula?
Once again, thank you so much for the help in this forum. It's amazing!
Answers

use countifs formula to exclude the rows that contain the "Y"
=COUNTIFS(Health:Health, 'Medium Risk", Exclude:Exclude <> "Y")
to get a percentage =COUNTIFS(Health:Health, "Medium Risk", Exclude:Exclude, <> "Y") / COUNTIF( Exclude:Exclude, <> "Y")
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!