| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Suming of Column
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Suming of Column
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with Suming of Column
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" 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| suming every 3rd column | Excel Worksheet Functions | |||
| testing while suming | New Users to Excel | |||
| suming in add-ins | Excel Worksheet Functions | |||
| Suming a column to another worksheet | Excel Programming | |||
| suming across sheets | Excel Programming | |||
Linear Mode
