Can I use a formula to take a Value from a cell look up all the matches in a cokumn and then have separate values added together from another column from the corresponding rows?
Example: Lookup value = Week 15, Lookup Range Column L and add the corresponding values from Column F.
Cell A5=15; Cells L5:L6 = 15; Cells F5 = 5:00 (hours) & F6 = 2:00 (hours) to = 7:00 (total hours)
Example: Lookup value = Week 15, Lookup Range Column L and add the corresponding values from Column F.
Cell A5=15; Cells L5:L6 = 15; Cells F5 = 5:00 (hours) & F6 = 2:00 (hours) to = 7:00 (total hours)
