Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching criteria and summing
I have 2 worksheets, same workbook, with similar information and wish on a
3rd worksheet to add the like items together and also display the unlike items. EXAMPLE: SHEET 1 SHEET 2 A B C A B C 1 ITEM QTY AMT ITEM QTY AMT 2 2x4x8 8 $24.00 4X4X8 2 $16.00 3 4x4x8 10 $80.00 2x6x8 10 $50.00 4 2X10X8 2 $24.00 Note that not all products are listed on each sheet and the order will change monthly. Thank you. -- Arturo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Criteria Summing | Excel Worksheet Functions | |||
matching and summing across sheets | Excel Discussion (Misc queries) | |||
Summing certain criteria - Advanced | Excel Discussion (Misc queries) | |||
Need Help: Summing Multiple Criteria | Excel Worksheet Functions | |||
Summing based on 2 criteria | Excel Discussion (Misc queries) |