Taking the Average of a Formula

[JimS]

How can I average the result of the following formula?

=SUMPRODUCT(--($G$15:$G$2500=$M$15:$M$2500),--($O$15:$O$2500="e"),--($Y$15:$Y$2500="e"),($N$15:$N$2500))

 

[T. Valko]

Try this array formula** :

=AVERAGE(IF(($G$15:$G$2500=$M$15:$M$2500)*($O$15:$O$2500="e")*($Y$15:$Y$2500="e"),$N$15:$N$2500))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

 

[JimS]

Works great, thanks Biff.

 

[T. Valko]

You're welcome. Thanks for the feedback!