Help with Suming of Column
Thanks for the help. It worked...
--
Regards,
Michael
"Per Jessen" wrote:
Hi Michael
Why not use the SubTotal function.
Select your data table, and goto Data Subtotal Follow the instructions
Hopes this helps.
---
Per
"Michael from Austin" skrev i
meddelelsen ...
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..
--
Regards,
Michael
|