One way is to just nest another IF test.

Array entered:


=IF(I1019="","",MAX(IF(G3:G1002H3:H1002,IF(E3:E10 02F3:F1002,I3:I1002))))

This has the meaning of:

IF G3:G1002H3:H1002 *and* IF E3:E1002F3:F1002 on a cell by cell basis.

--
Biff
Microsoft Excel MVP


"Struggling in Sheffield"
wrote in message ...
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.