#DIV/0! error Excel 2016

[Tesnobay]

hi, in Cells T4:T6 i will enter numbers, in T7 I will be averaging those 3 numbers. =Average(t4:t6). I drag that formulas across 20 column. I get the DIV error in the columns that have not been filled yet. Despite my best efforts, I cannot make the error go away and say return a blank or a 0 (zero).

this is a simplified version of my problem.

Please help

TIA

 

[jtakw]

Hi,

You can wrap your formula with IFFERROR:

Excel 2010
	T
1
Sheet11

Cell Formulas
Range	Formula
T1	=IFERROR(AVERAGE(T4:T6),"")

 

[Tesnobay]

Hi,

You can wrap your formula with IFFERROR:

Excel 2010

	T
1

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet11​

Worksheet Formulas Cell Formula T1 =IFERROR(AVERAGE(T4:T6),"") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you!!

 

[jtakw]

You're welcome.