=SUMIF / COUNT IF

or

=AVERAGE(IF(...)) entered as an array formula.

Dave
--
Brevity is the soul of wit.


"Steph" wrote:

Hi. Is there a way to create a formula that would essentially be an
averageif, similar to a sumif? Thanks!