Help sorting data into chart...

WillH

Hi,

I have a table which records serial numbers of parts and the number of hours they have been tested for. I need to create a chart showing how many hours each serial number has been tested for. Here is the table:

SSPC 1 & 2 are the same parts, can be used in either slot 1 or 2. I need to count the total number of vibe minutes and ESS hours for each serial number.

Thanks 😊

Will

Paul Newcome

You will need a second sheet that has every serial number listed out and then use a SUMIFS with cross sheet references to get your totals.