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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!