Conditional Array Formula

I

IPerlovsky

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

Lori

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

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

IPerlovsky

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
Trying to find additional ranges outside of min, max, and average 2
Forecast of Inventory - Explaination of Calcuations 1
Time Sum in Excel 1
Conditional IF formula using multi-dimensional arrays 2
Help Writing a SUM Formula 5
Working with arrays as arguments 6
Conditional formatting with multiple formula 2

Top