Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUBTOTAL function
Is there any way to total the values that are created by the sub-total
function in a grand total? I know the grand total is designed to IGNORE the SUBTOTAL function values when calculating the grand total, but how can I get it to include ONLY the SUBTOTAL function values? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUBTOTAL function
Why do you want to do that? How will it be different from the 'grand total'
excluding sub total values? "awb762" wrote: Is there any way to total the values that are created by the sub-total function in a grand total? I know the grand total is designed to IGNORE the SUBTOTAL function values when calculating the grand total, but how can I get it to include ONLY the SUBTOTAL function values? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUBTOTAL function
In a case where I have a continuity of numbers. For example, say I want to
track the number of units I have in inventory on a monthly basis. I have a column set up where each cell references the one above, then adds or subtracts purchases and sales from other columns to come to ending monthly inventory (ie in cell C2 I have the formula +C1+A2-B2. This formula is repeated 12 times in a column, and then this block of 12 is repeated for each individual inventory item. I'm trying to find a way to capture the last of those 12 values for each inventory item , so I can sum total units in inventory across multiple inventory items that all tracked on the same worksheet. "Sheeloo" wrote: Why do you want to do that? How will it be different from the 'grand total' excluding sub total values? "awb762" wrote: Is there any way to total the values that are created by the sub-total function in a grand total? I know the grand total is designed to IGNORE the SUBTOTAL function values when calculating the grand total, but how can I get it to include ONLY the SUBTOTAL function values? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUBTOTAL function
You must have some way to indicate which cells you want to add up
for example if you have the SubTotal in Col D for the rows you want to add up then use this formula =SUMPRODUCT(--(D1:D500="SubTotal"),(C1:C500)) Adjust 500 to your last row... this formula can be anywhere other than the range C1:D500 "awb762" wrote: In a case where I have a continuity of numbers. For example, say I want to track the number of units I have in inventory on a monthly basis. I have a column set up where each cell references the one above, then adds or subtracts purchases and sales from other columns to come to ending monthly inventory (ie in cell C2 I have the formula +C1+A2-B2. This formula is repeated 12 times in a column, and then this block of 12 is repeated for each individual inventory item. I'm trying to find a way to capture the last of those 12 values for each inventory item , so I can sum total units in inventory across multiple inventory items that all tracked on the same worksheet. "Sheeloo" wrote: Why do you want to do that? How will it be different from the 'grand total' excluding sub total values? "awb762" wrote: Is there any way to total the values that are created by the sub-total function in a grand total? I know the grand total is designed to IGNORE the SUBTOTAL function values when calculating the grand total, but how can I get it to include ONLY the SUBTOTAL function values? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal Function | Excel Discussion (Misc queries) | |||
Using Subtotal function | Excel Discussion (Misc queries) | |||
Subtotal function not available | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions |