How to do a MAXIF formula

C

Clay

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?
 
T

T. Valko

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
 
C

Clay

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

T. Valko

You're welcome. Thanks for the feedback!

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

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top