Finding Max Value with multiple criteria.

I have a large sheet that has a complex formula to make some long term growth calculations

I am trying to make a formula which will allow me to find the MAX amount in the sheet based on 3 criteria.
I know i can use the Max(IF(..... calculations but i cannot get this to work.

=MAX(IF(criteriax=#),IF(criteriaxx=#),IF(criteriay=#)))

I have tried the CSE format but it selects the first cell in the criteria which does not do what i want.

The sheet is on has a two x axis and one y that i want to use as criteria.

ie.

xx#####
xx#####
xx#####
y y y y y y

Hopefully there is a way i can make this work with the amount of options in the criteria i have.
So far i can only get it to work for the first cell of the IF function variable.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it is broken on this forum.

Hope this helps.

Pete

Hello and welcome to the forum.

Try something like this:

=MAX(IF((criteria range1=criteria1)*(criteria range2=criteria2)*(criteria range3=criteria3),Range to find the max of)) Ctrl Shift Enter

Thanks. I have tried this but get an error.
It does however work if my criteria is the first cell in the series

For example. If my IF is for A1:A10 it only works if I have =the value in A1.

See post #2.