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?