Need Help Using Excel Solver Tool

[tab10us]

I am trying to run solver, but I am having problems:

2 of my constraints have the reference cell listed as #DIV/0! obviously because I am dividing by 0. That is because the cell that is 0 is the sum of the amount in the variable cells that are to be changed. The cell won't change from 0 until solver is run, but solver won't run because of the #DIV/0! error in one of my constraints.

One of the formulas that is giving me the error is:
SUMPRODUCT(variable cells, cells with data)/sum of variable cells
Therefore, since the variable cells are currently blank, the sum is 0 and is producing the error.
The constraint is the answer from the sum product >=27

I was told that I somehow need to re arrange the formula, but I can't figure out what I can change around to get rid of the error.

PLEASE HELP!!!

 

[tusharm]

One obvious approach would be to populate one of the variable cells with a value of, say, 1.

Another would be to modify the formula along the lines of IF(SUM(variable cells)=0, a very large number, current formula)

I am trying to run solver, but I am having problems:

2 of my constraints have the reference cell listed as #DIV/0! obviously because I am dividing by 0. That is because the cell that is 0 is the sum of the amount in the variable cells that are to be changed. The cell won't change from 0 until solver is run, but solver won't run because of the #DIV/0! error in one of my constraints.

One of the formulas that is giving me the error is:
SUMPRODUCT(variable cells, cells with data)/sum of variable cells
Therefore, since the variable cells are currently blank, the sum is 0 and is producing the error.
The constraint is the answer from the sum product >=27

I was told that I somehow need to re arrange the formula, but I can't figure out what I can change around to get rid of the error.

PLEASE HELP!!!