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

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

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