How to do a MAXIF formula
 

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?

How to do a MAXIF formula
 

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?

How to do a MAXIF formula
 

T. Valko

THANK YOU, THANK YOU. I know you probably shook your head at such a stupid
question, but you don't realize how much time I put into figuring this out.
Thanks a million.

Clay

"T. Valko" wrote:

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?

How to do a MAXIF formula
 

You're welcome. Thanks for the feedback!

I know it's a cliche, but, there are no stupid questions!

Biff

"Clay" wrote in message
...
T. Valko

THANK YOU, THANK YOU. I know you probably shook your head at such a
stupid
question, but you don't realize how much time I put into figuring this
out.
Thanks a million.

Clay

"T. Valko" wrote:

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?