ElJarrodCopper ContributorDec 06, 2019How 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!
GavreaCopper ContributorDec 07, 2019u want to get rid of DIV 0 errors =if(ISERROR(A1/A2),"",A1/A2) ElJarrod Remove div 0 in average formulas the result.jpg16 KBRemove div 0 in average formulas.jpg34 KB
Wyn HopkinsMVP to GavreaDec 07, 2019Hi GavreaEasier to use IFERROR these days. It replaces most use cases of IF(ISERROR
