I have an excel table which expresses invoices generated. Rows are used one by one to display each item on that invoice. Column “D” displays the part number. Column “C” lists the invoice number,.
So if invoice 2110 has two items on it, there will be two rows representing this invoice. Each having a identical value in column C.
Column R shows the extended value of each row. I would like to accumulate the sum column of R for a group of rows pertaining to the same invoice number, as shown in column c, and display that answer in column S.
Therefor if done properly… S will have only one value for each invoice ( which may be represented by 2 or more rows ).
I have up loaded a sample file.....
Can u help.