If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|