"AverageIf"

[fozzie888]

I want to create a formula along the lines of a "SumIf" but for averages -
the target cells are blank and will be filled in later, so until they are the
formula cell displays #DIV/0!, which not only annoys me (!) but does not look
professional. Any suggestions?

 

[T. Valko]

I want to create a formula along the lines of a "SumIf" but for averages

I assume that means you want to do a conditional average: AVERAGE(IF(...

What does your formula look like?

What version of Excel are you using?

 

[Shane Devenshire]

Hi,

If you are using 2007 try this

=IFERROR(AVERAGE(A1:A10),"")