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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!