Taking the Average of a Formula

J

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

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)
 
Top