Forum Discussion
Sum of values in a column based on corresponding values in another
How to add values in Column K if their corresponding L values match?
You can create a pivot table based on the data. Add 'Batch Only' to the Rows area and 'QC Time' to the Values area.
By default, Excel will count the QC Time values because there are text values.
Click on the Values field, select Value Field Settings... and change the summary function from Count to Sum.