"AverageIf"
 

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?

"AverageIf"
 

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?

"AverageIf"
 

Hi,

Try this

=IF(COUNT(A1:A10),AVERAGE(A1:A10),"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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?

"AverageIf"
 

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?

--
Biff
Microsoft Excel MVP


"fozzie888" wrote in message
...
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?

"AverageIf"
 

Hi,

If you are using 2007 try this

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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?