| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selective summing of table items?
How do I write a function to sum the all the quatities in the item table
named named "Table" B2:C7 that match the product name in cell named "Product" A1? a b c 1 prodx 2 Item Quan 4 prodx 100 5 prodx 200 6 prody 20 7 prodz 40 8 prodx 100 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Sum items in a lookup table. | Excel Discussion (Misc queries) | |||
| Pivot Table: How can I organize data items in a row? | Excel Discussion (Misc queries) | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Threaded Mode
