Sum Multiple Values by Serial Numbers in Corresponding Cells

Hi,

I have a spreadsheet with a list of about 3800 lines of dollar values in "K" that correspond to various serial numbers in "E"
These serial numbers come up multiple times at different place throughout the 3800 lines.
I know by using SUMIF I can calculate the total value of each serial number, but is there a way to bring the serial numbers across to correspond to the sum of the dollar values?

Thanks.

I don't understand what you want to do.

Can you post an example spreadsheet showing desired outcome?

Book1.xlsx

Attached.

Pivot Table on the data range, G13:H23

"SERIAL NUMBERS" drag-and-drop as a Row Label.
"VALUES" (Sum of, the default option) drag-and-drop as a Value field.

Done.

That's probably the "best" solution.

Thanks for that!