Sum of values in a column based on corresponding values in another

Copper Contributor

Screenshot 2024-05-21 141247.jpg

How to add values in Column K if their corresponding L values match?

3 Replies

@VarshaGottipati 

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.

@VarshaGottipati You can use combination of few functions.

 

=HSTACK(UNIQUE(B2:B13),SUMIFS(A2:A13,B2:B13,UNIQUE(B2:B13)))

 

 

Harun24HR_0-1716347435264.png

 

@VarshaGottipati 

This is soon to be released from beta testing in excel 365.

= GROUPBY(batch, qc_time, SUM,,0)

Variations of the formula parameters allow it to insert headers or total rows in the same manner as a pivot table.