Adjustable total

[Tris69]

hello 

I want to make the last column adjustable so where the 5800 i want to add my own weight example 6000 into E14 and what to know the various weights of the ingredients

is there a way or function i can do this

[#2]

@Tris69 

Enter the following formula in E7:

=C7/C$14*E$14

Fill down to E12.

[#3]

You are a Hero THank you Thank you Thank you

@Hans Vogelaar