=SLOPE(IF((J2:J2000=E8)*(K2:K2000=E9),M2:M2000),N2 :N2000)

array-entered works in xl2003 and similarly for INTERCEPT, RSQ, FORECAST.



"IPerlovsky" wrote:

I often use some variation of the following formula to achieve conditional
MAX, MIN, AVERAGE, etc.

=MAX(IF((J2:J2000=E8)*(K2:K2000=E9),M2:M2000))

How would I change this formula to achieve a conditional array formula such
as INTERCEPT, SLOPE, etc.
--
iperlovsky