Counting number of rows that each have their own count
I would like to create a summary field in the following situation.
We have a sheet where users log hours. They can have multiple rows for different days. We want to keep track of how many users log hours greater than a certain number in a 90 day period.
For example, we want to count the number of individuals with hours greater than 12.
User 1 - 4 hours
User 1 - 10 hours
User 2 - 4 hours
User 2 - 4 hours
I would like a count to return that 1 of these two users has logged more than 12 hours. I would need a COUNT function for each user, then a COUNT of those counts that are greater than 12.
Also, can this be done without hardcoding the user in the formulas?
Answers
-
Kindly try leveraging with functions like COUNTIFS and TODAY()
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!