Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i insert a subtotal from a range of dates | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Subtotal function with Filtered Data | Excel Discussion (Misc queries) | |||
How do I copy Summary totals only from a subtotal list? | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |