How to use reverse SUM ?

[huberkinky]

I'm total newbie in Excel and I need just one formula. It could be tricky one or (I hope) is simple.

SUM is very simple. I would like to reverse it!

Sample - different paint tinters which I'm using to make a formula to make a color.

AM01 white - 120
AM06 black - 80
AM64 magenta -800

SUM - 1000

That's very ease. :-)

I would like to reverse it!


If I want not 1000 but 4000 (4l) or 20000.

I mean - if I will put 4000 in sum cell, all three components - colors with change automatically to:

AM01 white - 480
AM06 black - 320
AM64 magenta -3200

SUM - 4000


I need it for paint mixes and if I want different quantity, (240, 1545, etc) all I can do is to put such amount, and all components will be adjusted automatically. There are some programs for paints (DUPONT, STANDOX) who are making such programs. It's not for them!

Can this be done easy in Excel?



PLEASE HELP!

TIA

[teylyn]

Hello,

if your base is 1000 and you now want a base of 4000, you just need to multiply every value by 4.

That's just simple maths, not Excel.

cheers,

[tom1977]

Hi
If you know % of every paint in mixture it could be done very easy.

[teylyn]

see attached file. Enter your factor in the yellow cell.

cheers,

[huberkinky]

MANY THANKS!

It's so simple but I'm a moron.

THANX AGAIN!

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save