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
-
Try a SUMIFS...
=SUMIFS(Hours:Hours, Date:Date, @cell = DATE(2022, 07, 07), [Type Of Class]:[Type Of Class], @cell = "Academy Class")
Answers
-
Try a SUMIFS...
=SUMIFS(Hours:Hours, Date:Date, @cell = DATE(2022, 07, 07), [Type Of Class]:[Type Of Class], @cell = "Academy Class")
-
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
Categories
Check out the Formula Handbook template!