Prorate amount based on multiple conditions

[duh!boy]

Would greatly appreciate it if someone could provide a prorating formula. What I want is to prorate the amounts in D2 over the values in C2.
There are multiple transactions in column A and for each transaction, there can be anywhere from 1 to several lines (column B), with each
line having value a in C. The prorate amts are always on the first line of each transaction. Lines (B) are not necessarily unique within a given transaction
and I'm not even sure if they play a part in the equation. I'm looking for results as per column E.

	A	B	C	D	E
1	Transaction #	Transaction Line	Value	Prorate Amt	Expected Results
2	13284634688276	1	16891.69	422.09	422.09
3	13284634832909	1	1241.26	233.72	29.59
4	13284634832909	2	7191.41		171.44
5	13284634832909	3	1371.29		32.69
6	13284634838028	1	6477.89	313.34	313.34
7	13284634838108	1	4332.22	522.52	176.18
8	13284634838108	1	6755.89		274.74
9	13284634838108	1	1760.63		71.60
10	13284634838255	1	1888.8	1070.88	26.85
11	13284634838255	2	2102.23		29.89
12	13284634838255	2	5618.39		79.88
13	13284634838255	3	8999.02		127.94
14	13284634838255	4	2272.33		32.31
15	13284634838255	5	14910.33		211.98
16	13284634838255	6	39533.46		562.04

<colgroup><col style="mso-width-source:userset;mso-width-alt:2450;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:3657;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> </colgroup><tbody>
</tbody>

 

[wideboydixon]

Given the format of the data, it should be OK to use SUMIF:

Book1
	A	B	C	D	E
1	Transaction #	Transaction Line	Value	Prorate Amt	Expected Results
2	13284634688276	1	16891.69	422.09	422.09
3	13284634832909	1	1241.26	233.72	29.59
4	13284634832909	2	7191.41		171.44
5	13284634832909	3	1371.29		32.69
6	13284634838028	1	6477.89	313.34	313.34
7	13284634838108	1	4332.22	522.52	176.18
8	13284634838108	1	6755.89		274.74
9	13284634838108	1	1760.63		71.60
10	13284634838255	1	1888.8	1070.88	26.85
11	13284634838255	2	2102.23		29.89
12	13284634838255	2	5618.39		79.88
13	13284634838255	3	8999.02		127.94
14	13284634838255	4	2272.33		32.31
15	13284634838255	5	14910.33		211.98
16	13284634838255	6	39533.46		562.04
Sheet1

Cell Formulas
Range	Formula
E2	=SUMIF($A$2:$A$16,$A2,$D$2:$D$16)*$C2/SUMIF($A$2:$A$16,$A2,$C$2:$C$16)

WBD

 

[duh!boy]

Awesome! Thank you so much WBD. 896 lines prorated in 2 seconds. Commerce would come a screeching halt without you guys.