Thread: Maxif equivalent
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
  
Posts: 623
Default Maxif equivalent
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