Handle that using ISERROR()

=IF(ISERROR(AVERAGE(A1:C1)),"",AVERAGE(A1:C1))

If this post helps click Yes
---------------
Jacob Skaria


"fozzie888" wrote:

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?