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!
ElJarrod =Averageif(B3:B318,"<>#DIV/0!") , can change range as you need will exclude those regardless of how many and wherever they occur.
OR
in your autosum cell you can edit sum formula like this =SUMIF(D6:D14,"<>#DIV/0!") this will eliminate them in first place hence you don't need to do in average.
Thanks.