View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] drolfe@nelsonwatson.com is offline
external usenet poster
 
Posts: 3
Default 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.