Define cell value in a matrix to add up 2 constraints value

G

gila_cokelat

I have a matrix to match same SUM value (550) from left-right and up-down
X Y Z Total
A 100 90 80 270
B 70 0 60 130
C 0 50 40 150
TARGET 200 150 200 550

VARIANCE 30 10 20

Seems like I still have discrepancy with up-down summary. I must change
matrix (AX : CZ cells) value so that don't affect my left-right summary. How
to use solver for this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simplify a large nesting string to use in Excel 2003 1
How to dynamically add up varying # of cells base on a value 6
How can I use a sheet in a formula based on the value in a cell 2
Listbox execute SQL error 2
Simpler way to pull a cell value from a group based on 2 factors? 1
Detail in form goes blank 5
How to create a 3D surface graph from 3 columns of data: one columnfor x, one for y, and one for z 3
trying to retrieve a cell from table in sheet 2 to sheet 1 1

Top