| 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. |
| 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) | |||
Threaded Mode
