# How can I sum hours from a single day/class?

Options
✭✭✭

Hi, I am using this sheet as a work log, to count the hours a coach has spent with a group of students. For tracking purposes, coaches input 1 form per student, but I need to sum, in the example picture attached, only 1 class of 2 hours for that coach. So if the date and the type of class are the same I should only sum 2 hours for this coach. Is there a formula to calculate this?

• ✭✭✭✭✭✭
Options

Try a SUMIFS...

=SUMIFS(Hours:Hours, Date:Date, @cell = DATE(2022, 07, 07), [Type Of Class]:[Type Of Class], @cell = "Academy Class")

• ✭✭✭✭✭✭
Options

Try a SUMIFS...

=SUMIFS(Hours:Hours, Date:Date, @cell = DATE(2022, 07, 07), [Type Of Class]:[Type Of Class], @cell = "Academy Class")

• ✭✭✭
Options

Thank you! I actually used the

=COUNT(DISTINCT(COLLECT

to be able to skip duplicate dates and count only classes.

Thanks a lot anyway =)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!