Conditional Array Formula

G

Guest

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.
 
G

Guest

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

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

Guest

brilliant, thank you...
--
iperlovsky


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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array Formula Question 6
Conditional formatting with multiple formula 2
Conditional formula using MIN function doesn't work 5
IF OR AND in same conditional formula 2
Conditional Format 4
Blank cell in formula 1
Conditional Formatting Function for Anniversary Dates 5
Which formula(s) do I need? 3

Top