Max-If-And in one formula

Hi everybody,

I am trying to connect the MAX, IF & AND functions in one formula, which is supposed to refer to the entire data within the given table. My goal is to pick up the greatest number from the column that fulfils the conditions that I try to filter by the means of IF & AND functions.

I have attached the excel-file. There is some explanation next to the table. I hope that somebody can help me!

Thank you very much!

Cheers!

AND doesn't work that way in an array formula..

Try
=MAX(IF((B3:B27="")*(C3:C27=1)*(D3:D27=1)*(E3:E27=1)*(F3:F27="")*(G3:G27="")*(H3:H27="");L3:L27))

Thanks a lot!
It works!!!