Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif/SumProduct/lookup question
I want to insert subtotals only for items containing at least two specified
costs. A B C 1 Item Name Cost Title Cost Value 2 Item 1 Cost 1 5 3 Item 1 Cost 2 3 4 Item 1 Cost 3 4 5 Item 1 Cost 4 1 6 Item 2 Cost 1 9 7 Item 3 Cost 3 6 This setup continues for 28,000 rows. I want to separately sum all the cost values for each item number which contains both a cost 1 and cost 2. Are conditional subtotals possible, so that only items meeting the criteria would be subtotaled? I would also be interested in capturing the value of the corresponding item's cost 1 in the cell adjacent to the item's subtotal - in this example, the value 5 from cell C2 would be insertee in the cell next to the item's new subtotal. What formula could be used for this separate function? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif/SumProduct/lookup question
Is there a better way to accomplish this? Instead of conditional; subtotals,
is it possible to extract all costs for every item which contains the two specified costs and move them to a different tab in the spreadsheet? A pivot table could then be used to provide item totals. "Confused in TX" wrote: I want to insert subtotals only for items containing at least two specified costs. A B C 1 Item Name Cost Title Cost Value 2 Item 1 Cost 1 5 3 Item 1 Cost 2 3 4 Item 1 Cost 3 4 5 Item 1 Cost 4 1 6 Item 2 Cost 1 9 7 Item 3 Cost 3 6 This setup continues for 28,000 rows. I want to separately sum all the cost values for each item number which contains both a cost 1 and cost 2. Are conditional subtotals possible, so that only items meeting the criteria would be subtotaled? I would also be interested in capturing the value of the corresponding item's cost 1 in the cell adjacent to the item's subtotal - in this example, the value 5 from cell C2 would be insertee in the cell next to the item's new subtotal. What formula could be used for this separate function? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF or SUMPRODUCT or ?? | Excel Discussion (Misc queries) | |||
SumIF or SumProduct | Excel Discussion (Misc queries) | |||
Sumproduct/SumIf | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Complicated SUMPRODUCT OR SUMIF question? | Excel Discussion (Misc queries) |