<div>
<div class="content wysiwyg-content">
I have a table that has averages and stdeva - the later of which is an array. &nbsp;I want to have all the #DIV/0!'s hidden until there is an actual calculation. <br />
Any help would be as always greatly appreciated :)<br />
<br />
Ok so i cant attach my file so will do the best i can to explain....<br />
<br />
I was able to write: &nbsp;<br />
=IFERROR((AVERAGEIF(Summar<wbr />y!$C$2:$C$<wbr />61,A3,Summ<wbr />ary!$G$2:$<wbr />G$61)),&quot;&quot;)<wbr /> &nbsp;<br />
... this works for all cells except the array one.<br />
<br />
How do I get this to hide until it calculates.... right now it shows the #DIV/0!<br />
{=STDEV(IF(Summary!$C$2:$C<wbr />$61=A3,Sum<wbr />mary!$G$2:<wbr />$G$61))}
</div>
</div>


I have a table that has averages and stdeva - the later of which is an array.  I want to have all the #DIV/0!'s hidden until there is an actual calculation. 
Any help would be as always greatly appreciated :)

Ok so i cant attach my file so will do the best i can to explain....

I was able to write:  
=IFERROR((AVERAGEIF(Summary!$C$2:$C$61,A3,Summary!$G$2:$G$61)),"")  
... this works for all cells except the array one.

How do I get this to hide until it calculates.... right now it shows the #DIV/0!
{=STDEV(IF(Summary!$C$2:$C$61=A3,Summary!$G$2:$G$61))}

Hide error on forumal until calculated - formula is an Array

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.