Average for non-contiguous cells

[BrentL]

Hey Everyone,

I've been scouring the internet trying to find a solution for this but I'm stumped.

I've got a lot of data I'm running a lot of different average calucalutoin on a large amount of non-contiguous cells ( day average, weekly average, monthly etc) and i've getting the "#DIV/0!" error as a lot of the input is not yet entered, I've trying to get the formula to exclude the blank cells so when the formula runs, I want it to return "" if no data has been input yet, is this possible.

Currently just using the basic average formula as below,

=AVERAGE(AD8,AP8,BB8,BN8,BZ8) this without data input returns

Thanks in advance,

 

[Joe4]

Welcome to the Board!

Just wrap you current formula in an IFERROR statement, i.e.

=IFERROR(AVERAGE(AD8,AP8,BB8,BN8,BZ8),"")

 

[BrentL]

Of course it was that simple Thanks so much

 

[Joe4]

You are welcome.
Glad I was able to help!