Forum Discussion
How to exclude specific cells from an AutoSum?
Is it possible to do something like... =AVERAGE(B2:B318) -- except for B7, B100, B103, and B258 How does one write that? Thanks in advance!
mathetes Thanks for recommending AVERAGEIFS, that will come in handy.
To answer your question, the reason I was trying exclude specific cells is because I had some div/0 things happening that were making it so my AutoSum Average, Median, and Quartiles weren't working. I realized there were very few instances of div/0 though, so I just manually turned them into zeros and the functions calculated out correctly.
ElJarrod Wyn's suggestion is a better one than turning those error messages into zero--doing that will distort (perhaps only slightly) the averages that result.
If possible though (and maybe it's just not that important), it would be better overall to deal with the underlying problem and eliminate those DIV/0 errors to begin with.