Max function based on multiple criteria

[dobracik]

Hi all :-)

I just have one quick question. I need to find max value from raw data based on 3 conditions.
Do you know,how to write that max if something functions?

Thank you,
Andy :-)

[JohnTopley]

Try

=MAX(IF(condition1)*(condition2)*(condition3), Result))

Entered with Ctrl+Shift+Enter

Better to post a workbook showing expected results.

[dobracik]

Hi John,

attaching sample file. Max value should be from column "I" based on Building, Date and Server :-)

I was getting always zeros, fighting with that for a whole day.

[dobracik]

Actually I've done below functions based on 2 criteria,bud need another one, which is not working. getting zeros
=MAX(IF(Date_TypeA=$A5,IF(TSM_TypeA=$B$3,'Type A'!I:I)))

[dobracik]

Anybody who would be able to help me?

[José Augusto]

Try

=MAX(IF(condition1)*(condition2)*(condition3), Result))

Entered with Ctrl+Shift+Enter
...

See if this is what you want

Please Login or Register  to view this content.

See the file