Help with Suming of Column

  • Thread starter Thread starter Michael from Austin
  • Start date Start date
M

Michael from Austin

I need VBA code to sum the values in two columns even if the data is each set
that I need to sum varies in length exa.

Initial data

Quantity Amount
2 32.30

3 177.00

2 1,598.00
2 198.00

End result needed.

Quantity Amount
2 32.30
2 32.30 The sum of values above

3 177.00
3 177.00 The sum of values above


2 1,598.00
2 198.00
4 1,796.00 The sum of values above

I need it to do this until the end of the data..
Any help Would be deeply appreciated..
 
Hi Michael

Why not use the SubTotal function.

Select your data table, and goto Data > Subtotal > Follow the instructions

Hopes this helps.
 
Wow. didn't think the subtotal would work because I have empty rows
seperating them. It worked though. I feel like an idiot. Thanks for you help.
Sometimes the answer is staring you in the face:)
--
Regards,
Michael


Per Jessen said:
Hi Michael

Why not use the SubTotal function.

Select your data table, and goto Data > Subtotal > Follow the instructions

Hopes this helps.
Click to expand...
 
Thanks for the help. It worked...
--
Regards,
Michael


Per Jessen said:
Hi Michael

Why not use the SubTotal function.

Select your data table, and goto Data > Subtotal > Follow the instructions

Hopes this helps.
Click to expand...
 
Back
Top