View Single Post
  #1   Report Post  
Steven
 
Posts: n/a
Default MaxIF instead of SumIF

I am doing a SumIF( , , ) and that works fine. Is there a way to do a
MaxIf( , , ). I see in the help that there is no Maxif but what I want to
do is return the highest value for that particular occurance in the same data
that I am doing the SumIF.

Thank you for your help.

Steven