Hi,
I am trying to find a function to sum all the hours I have completed by project to see how much time in total has been spent on each project from a worksheet that resembles the below. Do you know what function could sum the totals 29, 45 & 46?
Project Mon Tue We Thu Fri
12345 8 4 2 1
10001 4
21211 6 7 8
12345 1 1 1 5
10001 7
21211 7 7 3 8
12345 6
10001 8 2 8 8 8
21211
Total 12345 = 29
Total 10001 = 45
Total 21211 = 46
TimeSheets_test.xlsx
Bookmarks