Thread: Maxif equivalent
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Maxif equivalent
Glad to help

--
Don Guillett
SalesAid Software

"Fred Smith" wrote in message
...
Thanks guys.

I was hoping to avoid arrays, and use the entire column reference, but
c'est la vie. Perhaps in a future version of Excel.

Your recommendation works perfectly.

--
Regards,
Fred


"Max" wrote in message
...
Try something like this, array-entered (press CTRL+SHIFT+ENTER):
=MAX(IF(I1:I100=A2,J1:J100))

Entire col references cannot be used
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fred Smith" wrote in message
...
I have a sumif formula, as in:

=sumif(I:I,a2,J:J)

I also want to calculate the maximum of the values which meet the
criteria. Is this possible?

--
Regards,
Fred









Reply With QuoteReply With Quote