| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total on filtered data?
I have what would appear to be a simple issue totaling filtered data as below
Dept count NESAS 1 NESAS 1 blabla 1 3 Rate 22 Total 66 How can I get the above to work when I filter the data? For instance if I filter by the code NESAS the sum should equal 2 NOT 3 and this would then give total of 44 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| count specific value with filtered data | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Charting Filtered Data | Charts and Charting in Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Threaded Mode
