"AverageIf"

  • Thread starter Thread starter fozzie888
  • Start date Start date
F

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?
 
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?
 
Back
Top