I am new to excel solver and I'm trying use it for what I think fairly simple task but it just won't work. 

I have 3 columns as follows:

```
%CHNG   |   PnL  |  Criteria met
  1     |    1   |      1         
 .5     |    2   |      2         
  2     |   -1   |      -1         
  3     |    6   |      6         
 -1     |   .5   |                
-.2     |   -5   |               

```

and the following 2 cells:

```
Criteria:   0

Total: =sum of criteria met column

```

When the number in the 'criteria' cell is changed the value in the 'criteria met' column is posted from the PnL column only if the value in the '%CHNG' column is greater than the value in the 'criteria' cell using an if statement. 

The 'total' cell is then the sum of the 'Criteria met' column. (The PnL values that are greater than the criteria value)

I am trying to get solver to maximize the 'Total' cell, by changing the value in the 'criteria' cell, however everytime I try this it leaves the criteria cell unchanged and claims a solution has been found. No matter what value I initially have in the criteria cell the solver claims that is the solution when it is run.

Is there any way to get this to work? preferably without VBA

Thank you