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

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?

Thank you in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!