As Mike H and Jacob have mentioned, there are several ways to overcome this.
IMO, it is an unneeded function as you can simply do:

=SUMIF(A:A,"Condition",B:B)/COUNTIF(A:A,"Condition")

Note that this is not an array formula.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"lisab" wrote:

I'm trying to average the values in one column if another column's value is
true. I know there is a sumif and a countif, but couldn not find an
averageif. Any help would be much appreciated!