Reverse Sum

Does anyone know if there is a way of having a reverse sum calculate in
excel?

For example, instead of 1+1+2=4, I would like to know variations of 3 numbers that are equal to 4.
In Cell A1 I have entered a 30. I want each cell from B1 to B10 to display a number such that B1+B10 = 30

Please help me, i need to calculate hundreds of data.



thank you

Hi chintan,

What's your criterias on what numbers to display...

For 30, can the first 9 cells equal to 1, then the last one equal to 21 (= 30-9)

There must be something that you are not telling us...

Hi
Sorry for half information,
I would like 30 to be distributed in 10 cells such that each cell display an integer between (1-5)

Thanks
Chintan

Hi Chintan,

Here's what I came up with... I have 2 formulas, one in column B and another for the rest...

With your criterias of 10 cells between 1-5, then your range is at most 10-50 (where 10 is ten 1s and 50 is ten 5s).

Anyway, here's my take... I'm sure there are plenty of other ways to do this...

Let me know if this works for you...

- Dennis