RE: How do I insert a filtered subtotal into overall summary

Giganews Newsgroups
Subject: RE: How do I insert a filtered subtotal into overall summary
Posted by:  Gary''s Student
Date: Thu, 25 May 2006

What you would like to do is change the filter criteria and get the subtotal
for each choise.

Much easier to use a pivot table:

http://peltiertech.com/Excel/Pivots/pivottables.htm

--
Gary's Student

"Mel" wrote:

> How do I insert a subtotal from a filtered list into an overall summary? I
> have a column for tracking eg offloading, en route, POD's delivered etc. I
> can establish subtotals in the filtered list but would like to have a summary
> at the end of my worksheet with a breakdown of each one?

Replies

In response to

How do I insert a filtered subtotal into overall summary posted by Mel on Thu, 25 May 2006