View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Struggling in Sheffield[_2_] Struggling in Sheffield[_2_] is offline
external usenet poster
 
Posts: 66
Default MAX value but with two comparison filtering criteria

Hi again chaps,
I'm using the following array formula to determine the MAX value in column
I3:I1002:

{=IF(I1019="","",MAX(IF($G$3:$G$1002$H$3:$H$1002, I3:I1002)))}

I get the MAX value from column I3:I1002 but only where corresponding values
in G3:G1002 are larger than the values in H3:H1002.

This appears to work fine but I now need the MAX value not only with
G3:G1002H3:H1002, but also where E3:E1002F3:F1002.

If someone could work the additional criteria into my formula it's be a
great help.
Many thanks for looking.