View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IPerlovsky IPerlovsky is offline
external usenet poster
 
Posts: 32
Default Conditional Array Formula

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