Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a long list of items with amounts sold and unit prices. I want to add
up anything that is the same item and price. Example: Qty Item: Price 1 TC001 $23 15 TC001 $20 3 TC001 $23 2 TC002 $44 2 TC003 $231 2 TC001 $23 1 TC003 $231 6 TC002 $40 Should return something like Qty Item Price Total 6 TC001 $23 $138 15 TC001 $20 $300 2 TC002 $44 $88 6 TC002 $40 $240 3 TC003 $231 $693 I will have many different items and different prices. TIA! Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct vs. countif | Excel Discussion (Misc queries) | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |