Hi guys, I hope you're in good health. I've a question about summing a number of rows, each with a cell with multiple values. It's a strange output file from an aircraft manufacturer that I need to cleanup.
As you can see, column H has multiple values corresponding to each panel in column G. I'd like to sum these values so I can see time for each task reference in column A.
It becomes issue in Cell 'G227', i'd like this cell to show 0.01 + 0.01 (0.02) and so on for rest of the column. But I need a solution that doesn't involve counting each cell, or splits the cells so that the reference in column A becomes 'detached' as it where. What I mean to say is, if I sort by column B time, I'd like the values that should 'stick' to Column A's reference to stay with it.
Is it possible to do this quicker than going through each cell manually? I've attached sheet.
Bookmarks