How to exclude a cell(s) from a range w/o mult. ranges on any fcn

C

civileng

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
 
D

David Biddulph

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)) ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use an formula to transpose a list(left) to be like the right? 2
How do I exclude a cell from a range? 4
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
How do I drag a hyperlink series to fill instead of copy? 2
creating multiple worksheets from one 0
Autofill cells in 1 column :code ?? 2
Simple Macro to "Lookup -> Repeat" 4
need held for auto date calculation for adding years and substract 1

Top