Hi All,
I have an excel file which shows Sender Receiver and the Amount sent.
I would like to sum the amounts in Column D, when the sender and receiver in the row are the same.
For example
HTML Code:
Sender Receiver Amount
Row 1 Company A Company B 500
Row 2 Company A Company C 1000
Row 3 Company A Company B 2000
So, it will sum Row 1 and Row 3 only (as sender is the same and recevier is the same) and output will be as follows:
HTML Code:
Sender Receiver Amount
Row 1 Company A Company B 2500 (2000+500)
Row 2 Company A Company C 1000
So, after this I will have smaller number of rows showing sender, receiver and consolidated amounts.
Will be glad to hear your suggestions.
thank you
Bookmarks