A B C D
1 500
2 250
3 350
4 100 800 200


I am an excel novice (I would put me at a 4.5 out of 10)
I want excel to auto fill in the blanks (A-C, 1-3) for me. Column D and Row 4 are totals for each row/column.

Obviously - I know Row 4 needs to equal Column D.

But is there a solver that can find the numbers that satisfy both sums?

can someone suggest a link or tutorial? Or even the right way to identify this "opportunity"?

Can Excel even perform this action? Should I be using something else?! The output for this project has to be Excel compatible.

Thanks