MaxIFS help

Need some help, I am suffering brain lock..

I have some SUMIFS and AVERAGEIFS commands that work great... but I need to create a command to get the same values - but for the max values instead of the sum and average...

There other commands are

=SUMIFS('SB2015 RA Data'!C:C,'SB2015 RA Data'!$B:$B,">=4/13/2015 12:00:00 AM",'SB2015 RA Data'!$B:$B, "<=4/18/2015 11:00:00 PM")

=AVERAGEIFS('SB2015 RA Data'!C:C,'SB2015 RA Data'!$B:$B,">=4/13/2015 12:00:00 AM",'SB2015 RA Data'!$B:$B, "<=4/18/2015 11:00:00 PM")

Where 'SB2015 RA Data' is the name of the works sheet... Where my B Column is a list of dates and time in the following format .. basically "1/8/15 12:00 AM" all the way thru to "4/20/15 12:00 PM"

Both the average and sum are getting me values for a specific data range ie the value in the C column where the value of the B column is between 4/13/2015 12:00:00 AM and 4/18/2015 11:00:00 PM, but I need to identify the Max value in the same range... However, as there is no MaxIFS command (arrrrgh) I am trying the =MAX(IF command, but I keep drawing a blank as the criteria is different

Any help is appreciated...

Thanks
Jason

See if this helps: http://www.utteraccess.com/wiki/inde...inIf_AverageIf.