Trying to find a max value with multiple criteria

[boynejs]

I am trying to find the maximum stage value (column D) for numerous months (columns A and B). For example, if I want to get the maximum value for January 1949, it should come back with 4.70 feet. I get #VALUE with following formula. Any ideas on how to do this?

Jeff

[Bo_Ry]

Please try
=MAX(INDEX((A2:A16=F3)*(B2:B16=1)*D2:D16,))

[boynejs]

Thanks for the help! It works well for my example, but when I adjust it for the spreadsheet I am working on it generates an Index error.

Jeff

[boynejs]

This was my new equation...

=MAX(INDEX((Data!$A$1:$A$25714=A2)*(Data!$B$1:$B$25714=1)*Data!$D$1:$D$25714,))

Jeff

[boynejs]

I figured out why there was an error. There was an alphanumeric character in column D which was throwing the error. Thanks for the help Bo!