Notifications
Clear all
Topic starter
Hello Everyone,
I am trying to add totals of hours that are selected from courses on specific dates. I would like to select a course on the day and have it add into my totals bars for the individual through the whole month. In my sheet attached I have the formula=SUM(INDEX(AL$2:AL$9,MATCH(C2,AK$2:AK$9,0))). When I try to add more days or a range for the sum it gives me an error. Any help will do.
Thanks in advance,
David
Posted : 29/12/2020 12:08 pm
How about
=SUMPRODUCT(($AF$2:$AF$9=C2:AD2)*($AG$2:$AG$9))
Posted : 29/12/2020 4:19 pm
Topic starter
Fluff,
Thank you. This works perfectly.
V/r,
David
Posted : 29/12/2020 5:56 pm
You're welcome & thanks for the feedback
Posted : 30/12/2020 8:51 am
