Sum the values for different invoice Nymbers

[muhammad.haq1974]

I want to sum amount in new column for each invoice #
Invoice # Amount
30349 722
30349 0
30349 0
30350 160
30694 341
30712 271
30712 0
30713 284
30713 0
30714 244

[AlKey]

Enter this formula to get unique invoice numbers

in D2 and copy down

Please Login or Register  to view this content.

then use this formula to sum

in E2 and copy down

Please Login or Register  to view this content.

v	A	B	C	D	E
1	AWB	Invoice	Amount	Unique invoice numbers	SUM
2	9200199444	30349	722	30349	978
3	9200118406	30349	56	30350	160
4	9200014305	30349	200	30694	341
5	41027629790	30350	160	30712	1251
6	30613783874	30694	341	30713	834
7	9223882684	30712	271
8	9223883432	30712	980
9	9200184335	30713	284
10	9200081472	30713	550