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?

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?

Is it possible to write a formula to count the number of cells within that
column with offloading, the number of cells with en route etc.?

"Gary''s Student" wrote:

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?

Use COUNTIF, e.g.:

=COUNTIF(A2:A100,"offloading")
=COUNTIF(A2:A100,"en route")

Or, if you put the word in a separate cell, eg C1, then:

=COUNTIF(A2:A100,C1)

I've assumed the data is in A1 to A100 - adjust cell references to
suit.

Hope this helps.

Pete