Forum Discussion

Darcy Calkins's avatar
Darcy Calkins
Copper Contributor
Sep 27, 2018

Sum Data

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 Calkins13936480Aug 07 2018Aug 09 2018Additional Premium - New12.50%$1,263.00$157.90PERAug 2018
Darcy Calkins13936480Aug 07 2018Aug 09 2018Return Premium - New12.50%-$905.00-$113.14PERAug 2018
          
Darcy Calkins13936480Aug 07 2018Aug 09 2018 12.50%$358.00$44.76PERAug 2018
Excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Sep 28, 2018

    Please provide a sample file with the desired result.

     

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

     

Resources