How do I insert a filtered subtotal into overall summary
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? |
How do I insert a filtered subtotal into overall summary
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? |
How do I insert a filtered subtotal into overall summary
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? |
How do I insert a filtered subtotal into overall summary
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 |
All times are GMT +1. The time now is 12:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com