Duplicate Conditional Sum Formulas

[CCW]

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?

 

[Frank Kabel]

Hi
post your formula and your desired result. also take a look at:
http://www.cpearson.com/excel/relative.htm

 

[CCW]

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]

Hi
enter the formula with cTRL+SHIFT+ENTER

 

[CCW]

Thanks Frank - I meant to say thanks earlier for the tip but had to put out
fires!.

CCW