Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=MAX(IF(Q1:Q100=1,Y1:Y100))

Or, normally entered (just ENTER):

=SUMPRODUCT(MAX((Q1:Q100=1)*Y1:Y100))

Note: you can't use entire columns as range references in either formula -
Q:Q, Y:Y (unless you're using Excel 2007)

Biff

"Clay" wrote in message
...
I need Excel to do a MAX function, but only on a specified number of cells.
ie. I need it to MAX the cells adjoining cells that are sorted into groups
A,B,C or 1,2,3 seperately. This is what I have so far.
=IF(Q:Q=1,MAX(Y:Y),"") What am I doing wrong?