Sum Data

[Darcy Calkins]

I download an invoice in Excel format.  More than a 1000 rows and 9 columns.  what I would like to be able to do is to sum 2 or more (like) cells and generate a single row with the sum and all the other data from the 2 rows.  I have tried building a Pivot Table but the moment you ask for totals it includes another row of data.

Example

Darcy Calkins	13936480	Aug 07 2018	Aug 09 2018	Additional Premium - New	12.50%	$1,263.00	$157.90	PER	Aug 2018
Darcy Calkins	13936480	Aug 07 2018	Aug 09 2018	Return Premium - New	12.50%	-$905.00	-$113.14	PER	Aug 2018
Darcy Calkins	13936480	Aug 07 2018	Aug 09 2018		12.50%	$358.00	$44.76	PER	Aug 2018

[#2]

Please provide a sample file with the desired result.

And yes, I think a pivot table would be the way to go.