excel solver help

In you formula you are using "SUMIF" and "COUNTIF" but solve can't handle discontinuous functions like "IF", "COUNTIF" and "SUMIF"

You could substitue formula in C203 "=SUMPRODUCT(A2:A201,C2:C201)" and also use "SUMPRODUCT" in D203.

The number of players is quite big, to speed up things in Solver go "Options" and tick "Assume Liniar Model" and "Assume Non-Negative"

You need to change the constraint in range H203 to H207 since they all contain "COUNTIF" statement. If you just want to test Solver, just remove them form Solver and do a run.

Not sure but I think that the "Experimental Solver" found in Excel 2010 may be able to cope with discontinuous functions.

Alf

Alf

Thanks for that - I understand where you are coming from.

Do you know of a substitute formula I could use on cells H203 to H207?

Thanks very much!

Originally Posted by Alf

In you formula you are using "SUMIF" and "COUNTIF" but solve can't handle discontinuous functions like "IF", "COUNTIF" and "SUMIF"

You could substitue formula in C203 "=SUMPRODUCT(A2:A201,C2:C201)" and also use "SUMPRODUCT" in D203.

The number of players is quite big, to speed up things in Solver go "Options" and tick "Assume Liniar Model" and "Assume Non-Negative"

You need to change the constraint in range H203 to H207 since they all contain "COUNTIF" statement. If you just want to test Solver, just remove them form Solver and do a run.

Not sure but I think that the "Experimental Solver" found in Excel 2010 may be able to cope with discontinuous functions.

Alf