Taking the Average of a Formula

  • Thread starter Thread starter JimS
  • Start date Start date
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))
 
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)
 
Back
Top