| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can I use functions limited to selected records when autofilte
how can I use functions limited to selected records when autofilter is on?
|
|
#2
|
|||
|
|||
|
Take a look at the SUBTOTAL() function in the Help file. Despite its name,
it does much more - average, count, min, max, etc. If your formulas are more complicated, provide some examples of the types of calculations & you'll likely get better guidance "okhameed" wrote: how can I use functions limited to selected records when autofilter is on? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visible rows and functions that work | Excel Worksheet Functions | |||
| How can I add only on selected Criteria only? | Excel Discussion (Misc queries) | |||
| Perform oiperations relative to initial selected cell | Excel Discussion (Misc queries) | |||
| Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
| Limited IF Nested Level functions. | Excel Discussion (Misc queries) | |||
Linear Mode
