Summarizing Filtered Data

P

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
 
Top