Need help with MAXIF Formula for a Multiple Selection Criteria (9 selections)

[Fadil]

I have a summary with dropdown boxes and accodring to the selection I make, the table changes since I have put SUMIF formulas. I have created a chart that reads the data that is filtered and the chart is modified automatically.

Now, the summary is just a summary of multiple projects that fetches data from another table, the data table where I consolidate all the projects.

The issue I am having is, I want to build a table in the summary sheet to pull the Top Ten Highest or Lowest projects from the data sheet.
For example I have the following selection criteria in the summary:
Dropdown Box 1: Default value is *, and I have options to select
Dropdown Box 2: Default value is *, and I have options to select
Dropdown Box 3: Default value is *, and I have options to select
Dropdown Box 4: Default value is *, and I have options to select
Dropdown Box 5: Default value is *, and I have options to select

According to the selection I make, I want a table to pull the highest value from the data table, but there could be cases that the combo box could be let as default value * in which case should pull everything from that field.

Any advise.
Your help is greatly appreciated

 

[Fadil]

I have put this formula and it returns the correct value only if all dropdown boxes have a criteria selected, but if the dropdown box is left the default value * it does not pick up any value hence it returns zero
{=LARGE((Sheet1!C4:C276=Summary!B3)*(Sheet1!D4:D276=Summary!B5)*(Sheet1!E4:E276=Summary!B7)*(Sheet1!F4:F276=Summary!B9)*(Sheet1!G4:G276=Summary!B11)*(Sheet1!P4:P276),1)}

In Sheet1 Columns C, D, E, F and G have a value that can be found in dropdown boxes of Summary Sheet cells B3, B5, B7, B9 and B11 and under Sheet1 P column is the column that has the value I am trying to pull the max of it