Please help me how to make formula if as following case
 

Please help me how to make formula if as following case? Thank you very
much in advance to expert helpers.
I want divide a total amount of many diffrent product, in according to
there actual value of product of each product. as following example.
Actual invoice and value & The actual amount
Product quantity unit price total price
Bag 1000 2.1 $2,100
shoes 5000 3.1 $15,500
blanket 8000 4.32 $34,560
jacket 1500 1.8 $2,700
bed sheet 6000 6.8 $40,800
towels 3000 0.23 $690
============================================
Total $96,350

Under invoice
how to reduce (divide unit price and total amount according to each
product is actual invoice value )the total invoice amount result =
into 50000$

Product quantity unit price total price
Bag 1000 =? =?
shoes 5000 =? =?
blanket 8000 =? =?
jacket 1500 =? =?
bed sheet 6000 =? =?
towels 3000 =? =?
=============================================
Total $50,000

Please help me how to make formula if as following case
 

Unit is

=C2*50000/SUM($D$2:$D$7)

Prtice is

=D2*50000/SUM($D$2:$D$7)


and copy down for others


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rehman" <u18078@uwe wrote in message news:5ae53f7438429@uwe...
Please help me how to make formula if as following case? Thank you very
much in advance to expert helpers.
I want divide a total amount of many diffrent product, in according to
there actual value of product of each product. as following example.
Actual invoice and value & The actual amount
Product quantity unit price total price
Bag 1000 2.1 $2,100
shoes 5000 3.1 $15,500
blanket 8000 4.32 $34,560
jacket 1500 1.8 $2,700
bed sheet 6000 6.8 $40,800
towels 3000 0.23 $690
============================================
Total $96,350

Under invoice
how to reduce (divide unit price and total amount according to each
product is actual invoice value )the total invoice amount result =
into 50000$

Product quantity unit price total price
Bag 1000 =? =?
shoes 5000 =? =?
blanket 8000 =? =?
jacket 1500 =? =?
bed sheet 6000 =? =?
towels 3000 =? =?
=============================================
Total $50,000

Please help me how to make formula if as following case
 

See if this is what you're looking for:

With your data in Cells A1:D8

D2: =B2/SUM($B$2:$B$7)*$D$8
Copy down through D7

C2: =+D2/B2
Copy down through C7

That will allocate the total price of $50,000 amoung the products according
to their quantity percentage of the total of the quantities.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Rehman" wrote:

Please help me how to make formula if as following case? Thank you very
much in advance to expert helpers.
I want divide a total amount of many diffrent product, in according to
there actual value of product of each product. as following example.
Actual invoice and value & The actual amount
Product quantity unit price total price
Bag 1000 2.1 $2,100
shoes 5000 3.1 $15,500
blanket 8000 4.32 $34,560
jacket 1500 1.8 $2,700
bed sheet 6000 6.8 $40,800
towels 3000 0.23 $690
============================================
Total $96,350

Under invoice
how to reduce (divide unit price and total amount according to each
product is actual invoice value )the total invoice amount result =
into 50000$

Product quantity unit price total price
Bag 1000 =? =?
shoes 5000 =? =?
blanket 8000 =? =?
jacket 1500 =? =?
bed sheet 6000 =? =?
towels 3000 =? =?
=============================================
Total $50,000

Please help me how to make formula if as following case
 

I think you interpreted that request better than I did, Bob. :)

***********
Regards,
Ron

XL2002, WinXP-Pro


"Bob Phillips" wrote:

Unit is

=C2*50000/SUM($D$2:$D$7)

Prtice is

=D2*50000/SUM($D$2:$D$7)


and copy down for others


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rehman" <u18078@uwe wrote in message news:5ae53f7438429@uwe...
Please help me how to make formula if as following case? Thank you very
much in advance to expert helpers.
I want divide a total amount of many diffrent product, in according to
there actual value of product of each product. as following example.
Actual invoice and value & The actual amount
Product quantity unit price total price
Bag 1000 2.1 $2,100
shoes 5000 3.1 $15,500
blanket 8000 4.32 $34,560
jacket 1500 1.8 $2,700
bed sheet 6000 6.8 $40,800
towels 3000 0.23 $690
============================================
Total $96,350

Under invoice
how to reduce (divide unit price and total amount according to each
product is actual invoice value )the total invoice amount result =
into 50000$

Product quantity unit price total price
Bag 1000 =? =?
shoes 5000 =? =?
blanket 8000 =? =?
jacket 1500 =? =?
bed sheet 6000 =? =?
towels 3000 =? =?
=============================================
Total $50,000