Subfilter? Go pour yourself another cup of coffee, Dave
<g.

Jason

-----Original Message-----
Take a look at =subfilter() in Excel's help.

Or visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions01.html#Filter

Jonny wrote:

I have a cost sheet with lots of products in from
different manufacturers.
I then created a worksheet for an order to these
manufacturers, using the
autofilter to select which manufacturer I would like.
However when I insert a total at the bottom of the
order and use the 'sum'
formulae it totals up the costs for every manufacturer
not just the ones i
filtered.
What can I do?

--

Dave Peterson
.