Thread: Maxif equivalent
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Maxif equivalent
=SUMPRODUCT(MAX((I1:I100=A2)*J1:J100))


"Fred Smith" wrote:

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