| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to exclude a cell(s) from a range w/o mult. ranges on any fcn
=(SUM(A5:A20)-SUM(A10:A15))/(COUNT(A5:A20)-COUNT(A10:A15))
"civileng" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to exclude a cell(s) from a range w/o mult. ranges on any fcn
I think the OP wanted to exclude only A10 and A15, not the ones between.
Might be worth trying =(SUM(A5:A20)-SUM(A10,A15))/(COUNT(A5:A20)-COUNT(A10,A15)) ? -- David Biddulph "Teethless mama" wrote in message ... =(SUM(A5:A20)-SUM(A10:A15))/(COUNT(A5:A20)-COUNT(A10:A15)) "civileng" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
