Summarizing Filtered Data

[Patrick]

I have a sheet full of some sales and cost data...

Branch | PART | SALES | COST

I have a little script in the background that runs through
and summarizes the values and throws them onto a form to
display the totals. The user is able to autofilter on
their branch number... but I cannot seem to make my script
summarize ONLY the rows that meet the filter criteria...
in fact, I get some very strange data back when I try to.

Is there an easy way to to do this?

Much thanks! patrick

 

[Frank Kabel]

Hi Patrick
maybe not the solution you're directly looking for but have you
considered using a pivot table and let the user do their filtering in
the pivot table?. See the following sites for getting started with
pivot tables:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html