Forum Discussion
ElJarrod
Dec 06, 2019Copper Contributor
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!
Gavrea
Dec 07, 2019Copper Contributor
=AVERAGE(B2:B6,B8:B99,B101,B104:B257,B259:B318) -- excludes B7, B100, B103, and B258