Max If statement with multiple criteria based on specific text in a cell Issue

Here, try this:

Formula:

Please Login or Register  to view this content.

confirmed with ctrl+shift+enter

Hey thanks for that, and if i dont want it to max if column B has AA? would it be like search(<>"AA";B...)?

and if i decided to include more criteria would i keep adding the *Search()?

Rather something like:

Formula:

Please Login or Register  to view this content.

In first part: ISNUMBER(SEARCH("white";A2:A1000))
You can join all that you need for finding specific word (in case of more criteria)
and in second part ISERR(SEARCH("aa";B2:B1000)
you can join all that you don't want (hint <>)

Thanks Zbor,

my final question

if i wanted to add more criteria, what would that look like?

would I add in another *isnumber(search)?

This can vary depending how you want to organize your data.

For example: white and not AA AND black and not AA
Or: white OR black and not AA
or: white AND black and not AA OR not BB
...

There is large number of combinations and for igher number probably is best to create helper column where you can extract those criteria and then just finding MAX of that column.