Hello All,

I need a Max statement with multiple ifs.

Take for instance the example below, I need only the Max IF A=1 and C
= 1. I've tried formulas like {=MAX(IF(Sheet1!A:A=A2, Sheet1!C:C, IF
(Sheet1!E:E="yes", Sheet1!C:C)))} and {=IF(Sheet1!A:A=78, MAX(IF
(Sheet1!E:E="yes",Sheet1!C:C)))}, but I've had no luck so far.

So basically, for all values of A which are 1, I need the Max of B, if
C is also 1, then for all values of A which are 2, I need the Max of B
if C is 1, etc.

Thanks,

Chris

Example:

A B C

1 5 1

1 3 1

1 2 0

2 3 1

2 6 0

3 2 1

3 5 0

3 3 1