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()
Huma
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!