| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to exclude a cell(s) from a range w/o mult. ranges on any fcn
In an excel function, is it possible to exclude a cell or cells from a range.
Example: =Average(A5:A20), but exclude a few cells, say A10 and A15 I am aware of one way: =Average(A5:A9,A11:A14,A16:A20) but is there a possible way to exclude cells in a range within the fuction, such as =Average(A5:A20,not A10, not A15) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mult. w/sheets need identical view when opening (range, mag, cell) | Setting up and Configuration of Excel | |||
| Sum a range but exclude and negative values | Excel Worksheet Functions | |||
| Need to exclude certain cells in a range | Excel Worksheet Functions | |||
| Exclude Header from Range? | Excel Discussion (Misc queries) | |||
| Pivot Table: Mult Consolidation Ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
