MAXIFS Help

[Bolsa68]

Hi,

I am currently using excel 2010 and there is no "MAXIFS" function. Is there a workaround for this? I am trying to make something like this:

=SUMIFS(TableY[Zone Yield],TableY[Date],">="&B4,TableY[Date],"<="&B5)

Except with a MAXIFS instead of SUMIFS.
Any help would be extremely appreciated as I am really stuck on this one.

Many Thanks!

 

[BarryL]

to use MAX with if it needs to be an array (ctrl+shft+entr)

for example if you had a list of names in col A and number values in col B and you wanted Barry's max value it would be

=MAX(IF(A:A="Barry",B:B,""))

Entered with ctrl+shift+enter