Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Arrays - making a total formula
I have some data..
A - B - C -------------- a - 1 - 12 a - 2 - 13 a - 3 - 14 b - 4 - 15 b - 5 - 16 b - 6 - 17 i have the code to group the data by column A, and list column B as the Item Id, with C as the value all that works fine.. for the group header i have a total. my problem is that I having trouble making an array for the total of all the totals. The code itself is a Do loop exiting when there is no more data in the table to read. I guess basically what I am asking, is how can I add fields to the array on the fly, and then reference it at the end and produce a total of all of my totals. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a budget with excel, keep a running total | Excel Discussion (Misc queries) | |||
making a sum total | Excel Discussion (Misc queries) | |||
Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
Making charts from arrays in VBA | Charts and Charting in Excel | |||
Making arrays outside cells | Excel Programming |