Forum Discussion

ElJarrod's avatar
ElJarrod
Copper Contributor
Dec 06, 2019

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!
excel
mathetes's avatar
mathetes
Silver Contributor
Dec 08, 2019

Gavrea 

u want to get rid of DIV 0 errors =if(ISERROR(A1/A2),"",A1/A2)

 

You're right that this formula gets rid of the error message, but not of the underlying condition that is causing the DIV/0 error. There are times when (for data integrity reasons) you'd be better off seeking to eliminate the cause of the error rather than just masking over it. Not always; when that isn't needed your formula (or the one Wyn suggested) is worth knowing.

Gavrea's avatar
Gavrea
Copper Contributor
Dec 08, 2019

data integrity though is another question all together mathetes I agree

  • crazyshoots's avatar
    crazyshoots
    Brass Contributor
    Dec 09, 2019

    I would use iferror to remove any #div/0 or #value etc.

    so formula would work along the line for iferror(average...

Resources