Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicate Conditional Sum Formulas
Is it possible to copy a conditional sum formula to another cell so that only
one part of the formula has to be changed, rather than rewritting the whole equation? |
#2
|
|||
|
|||
Hi
post your formula and your desired result. also take a look at: http://www.cpearson.com/excel/relative.htm -- Regards Frank Kabel Frankfurt, Germany "CCW" schrieb im Newsbeitrag ... Is it possible to copy a conditional sum formula to another cell so that only one part of the formula has to be changed, rather than rewritting the whole equation? |
#3
|
|||
|
|||
I am trying to sum the total items dispositioned as scrap, etc. by week. I
have a "Week" column, a Disposition Collumn and a Quantity Column. Using the conditional sum wizzard gives me this equation, {=SUM(IF($A$3:$A$461=DATEVALUE("6/12/2004"),IF($K3:$K461="SCRAP",$J$3:$J$461,0),O))} Using the wizzard this works. However, If I copy the formula to another cell and change the date value or the disposition, (K3:K461="REWORK"), the value does not compute and the equation text is in the cell. Note the { }'s have been dropped from the front and back of the equation and #VALUE appears in the cell. Any thoughts? - They are appreciated! "Frank Kabel" wrote: Hi post your formula and your desired result. also take a look at: http://www.cpearson.com/excel/relative.htm -- Regards Frank Kabel Frankfurt, Germany "CCW" schrieb im Newsbeitrag ... Is it possible to copy a conditional sum formula to another cell so that only one part of the formula has to be changed, rather than rewritting the whole equation? |
#4
|
|||
|
|||
Hi
enter the formula with cTRL+SHIFT+ENTER -- Regards Frank Kabel Frankfurt, Germany "CCW" schrieb im Newsbeitrag ... I am trying to sum the total items dispositioned as scrap, etc. by week. I have a "Week" column, a Disposition Collumn and a Quantity Column. Using the conditional sum wizzard gives me this equation, {=SUM(IF($A$3:$A$461=DATEVALUE("6/12/2004"),IF($K3:$K461="SCRAP",$J$3:$ J$461,0),O))} Using the wizzard this works. However, If I copy the formula to another cell and change the date value or the disposition, (K3:K461="REWORK"), the value does not compute and the equation text is in the cell. Note the { }'s have been dropped from the front and back of the equation and #VALUE appears in the cell. Any thoughts? - They are appreciated! "Frank Kabel" wrote: Hi post your formula and your desired result. also take a look at: http://www.cpearson.com/excel/relative.htm -- Regards Frank Kabel Frankfurt, Germany "CCW" schrieb im Newsbeitrag ... Is it possible to copy a conditional sum formula to another cell so that only one part of the formula has to be changed, rather than rewritting the whole equation? |
#5
|
|||
|
|||
Thanks Frank - I meant to say thanks earlier for the tip but had to put out
fires!. CCW "Frank Kabel" wrote: Hi enter the formula with cTRL+SHIFT+ENTER -- Regards Frank Kabel Frankfurt, Germany "CCW" schrieb im Newsbeitrag ... I am trying to sum the total items dispositioned as scrap, etc. by week. I have a "Week" column, a Disposition Collumn and a Quantity Column. Using the conditional sum wizzard gives me this equation, {=SUM(IF($A$3:$A$461=DATEVALUE("6/12/2004"),IF($K3:$K461="SCRAP",$J$3:$ J$461,0),O))} Using the wizzard this works. However, If I copy the formula to another cell and change the date value or the disposition, (K3:K461="REWORK"), the value does not compute and the equation text is in the cell. Note the { }'s have been dropped from the front and back of the equation and #VALUE appears in the cell. Any thoughts? - They are appreciated! "Frank Kabel" wrote: Hi post your formula and your desired result. also take a look at: http://www.cpearson.com/excel/relative.htm -- Regards Frank Kabel Frankfurt, Germany "CCW" schrieb im Newsbeitrag ... Is it possible to copy a conditional sum formula to another cell so that only one part of the formula has to be changed, rather than rewritting the whole equation? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
conditional formulas in excel | Excel Worksheet Functions |