Count the total # cells with a specific word in a filtered column?
I have a COUNTIF but it is retruning a value that represents the entire sheet and not just the number of cells on the filtered sheet. Is it possible to restrict the formula to the filtered sheet only?
Answers
-
Hey @Heather_Goetz_DAL !
You should try the COUNTIFS function instead. You can add additional statements in countifs that are being used in your filter to restrict the data that is being counted. A formula will always count everything that is present (regardless of filter) so by adding additional IF restrictions, you can get the data you are looking for.
Hope this helps!
Ashley Knight
-
Thanks Ashley by chance do you have an example you can share. I am not sure how to use COUNTIFS. That is a new one for me.
Heather
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!