Is it possible to have a function like Sumif but for averages

  • Thread starter Engineering Accountant
  • Start date
E

Engineering Accountant

I need to average a set of numbers if they meet a criteria like sumif for
averages.

Does anybody have a function I could use.
 
D

Dave Peterson

How about using:

=sumif()/countif()



Engineering said:
I need to average a set of numbers if they meet a criteria like sumif for
averages.

Does anybody have a function I could use.
Click to expand...
 
Top