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