Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include filtered out numbers in a SUBTOTAL?
I am creating a spreadsheet that several different people (who all want to
see different aspects of the spreadsheet) need to use. I want to be be able to use the autofilter so that the various people can easily and quickly zero in on ONLY the information that they want to see, but then the SUBTOTAL functions get messed up. I do not want to use the SUM functions because there are so many subtotal lines it would be difficult to specify what needs be included/excluded in a SUM function. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include filtered out numbers in a SUBTOTAL?
CMDMHHS
What version of Excel are you using? I believe that this is addressed in Excel 2003. Dave "CMDMHHS" wrote in message ... I am creating a spreadsheet that several different people (who all want to see different aspects of the spreadsheet) need to use. I want to be be able to use the autofilter so that the various people can easily and quickly zero in on ONLY the information that they want to see, but then the SUBTOTAL functions get messed up. I do not want to use the SUM functions because there are so many subtotal lines it would be difficult to specify what needs be included/excluded in a SUM function. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include filtered out numbers in a SUBTOTAL?
Instead of filters and subtotals, you could create a pivot table to
summarize the data. There are examples and links he http://www.contextures.com/xlPivot01.html CMDMHHS wrote: I am creating a spreadsheet that several different people (who all want to see different aspects of the spreadsheet) need to use. I want to be be able to use the autofilter so that the various people can easily and quickly zero in on ONLY the information that they want to see, but then the SUBTOTAL functions get messed up. I do not want to use the SUM functions because there are so many subtotal lines it would be difficult to specify what needs be included/excluded in a SUM function. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include filtered out numbers in a SUBTOTAL?
Hi Debra,
Thanks for the response. Is there anyway to permanently override the pivot table formatting? I find that whenever I use pivot tables/charts, if I try to use any custom formatting (for example, resizing the columns so they fit better when printed, using colors to highlight certain totals, etc), my formatting is eliminated when the pivot table is refreshed. "Debra Dalgleish" wrote: Instead of filters and subtotals, you could create a pivot table to summarize the data. There are examples and links he http://www.contextures.com/xlPivot01.html CMDMHHS wrote: I am creating a spreadsheet that several different people (who all want to see different aspects of the spreadsheet) need to use. I want to be be able to use the autofilter so that the various people can easily and quickly zero in on ONLY the information that they want to see, but then the SUBTOTAL functions get messed up. I do not want to use the SUM functions because there are so many subtotal lines it would be difficult to specify what needs be included/excluded in a SUM function. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include filtered out numbers in a SUBTOTAL?
Hi Dave,
I am using Excel 2003 SP1 According to the Excel help files, I can use function_num = 9 to include "hidden" rows, but it will not include filtered out rows. "Dave" wrote: CMDMHHS What version of Excel are you using? I believe that this is addressed in Excel 2003. Dave "CMDMHHS" wrote in message ... I am creating a spreadsheet that several different people (who all want to see different aspects of the spreadsheet) need to use. I want to be be able to use the autofilter so that the various people can easily and quickly zero in on ONLY the information that they want to see, but then the SUBTOTAL functions get messed up. I do not want to use the SUM functions because there are so many subtotal lines it would be difficult to specify what needs be included/excluded in a SUM function. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I include filtered out numbers in a SUBTOTAL?
Right-click on the pivot table, and choose Table Options.
Turn off AutoFormat table, and your formatting should stick CMDMHHS wrote: Hi Debra, Thanks for the response. Is there anyway to permanently override the pivot table formatting? I find that whenever I use pivot tables/charts, if I try to use any custom formatting (for example, resizing the columns so they fit better when printed, using colors to highlight certain totals, etc), my formatting is eliminated when the pivot table is refreshed. "Debra Dalgleish" wrote: Instead of filters and subtotals, you could create a pivot table to summarize the data. There are examples and links he http://www.contextures.com/xlPivot01.html CMDMHHS wrote: I am creating a spreadsheet that several different people (who all want to see different aspects of the spreadsheet) need to use. I want to be be able to use the autofilter so that the various people can easily and quickly zero in on ONLY the information that they want to see, but then the SUBTOTAL functions get messed up. I do not want to use the SUM functions because there are so many subtotal lines it would be difficult to specify what needs be included/excluded in a SUM function. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUBTOTAL - TJ | Excel Worksheet Functions | |||
Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |