Max if formula incorporating OR function

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

You could use this perhaps:

=MAX(MAXIFS(one_set_of_criteria),MAXIFS(the_other_set_of_criteria))

One way:

=AGGREGATE(14,6,$B$3:$B$21/(($A$3:$A$21=F3)*($C$3:$C$21={"Full Inspection","Standard Inspection"})),1)

Yes, sure..

=AGGREGATE(14,6,$B$3:$B$21/(($A$3:$A$21=F3)*($C$3:$C$21={"Full Inspection","Standard Inspection"})),1)

red. When A3:A13= value in F3
green. And
orange. C3-21 is either FI or SI
Blue return the largest value (14 = large, 15 = small)
Black from this range


You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.