Help with Suming of Column

[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..

 

[Per Jessen]

Hi Michael

Why not use the SubTotal function.

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

Hopes this helps.

 

[Michael from Austin]

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

Hi Michael

Why not use the SubTotal function.

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

Hopes this helps.

 

[Michael from Austin]

Thanks for the help. It worked...
--
Regards,
Michael

Hi Michael

Why not use the SubTotal function.

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

Hopes this helps.