Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ON SUBTOTAL LINE CARRY FORWARD DENOMINATOR FROM PREVIOUS LINE
I have a spreadsheet that computes a unit cost per raw material divided by
total tons produces. I am subtotaling at two breaks. Is there an easy way to carry the tons produced, which is a static figure per each break, down to the subtotal and grand total lines? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ON SUBTOTAL LINE CARRY FORWARD DENOMINATOR FROM PREVIOUS LINE
Type an = into the cell where you want the "tons produced" figure to appear,
then click on the cell containing the "tons produced" figure. This will create a formula in the cell which will reproduce the required figure and will update if the original figure is changed. Hope this helps "Pam M" wrote: I have a spreadsheet that computes a unit cost per raw material divided by total tons produces. I am subtotaling at two breaks. Is there an easy way to carry the tons produced, which is a static figure per each break, down to the subtotal and grand total lines? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I carry forward formula to next page of workbook? | Excel Discussion (Misc queries) | |||
Goal Line Going Forward | Charts and Charting in Excel | |||
How do I insert a line in excel and carry the formula forward? | Excel Discussion (Misc queries) | |||
Carry forward formula help needed | Excel Discussion (Misc queries) | |||
How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions |