i have a column contains products names and another column contains the prices of these products, in the products names column the product could be repeated,
i want to sum the costs of the repeated product
Example:
Product Name Price A 20 B 10 A 5 C 30 B 50 A 15 C 7
i want to search for the repeated product Name , and sum the corresponding values in the Price column
can any one help me please!
Last edited by Fatima Morad; 01-31-2012 at 08:20 AM.
Best option would be a PivotTable. It would help to format the data as a Table & refer to the Table as the PivotTable source
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
It was very helpfull
thanks alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks