Thread: "AverageIf"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fozzie888 fozzie888 is offline
external usenet poster
 
Posts: 1
Default "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?