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?
