Copy and Paste Conditional Sum Formula

  • Thread starter Thread starter David Kinkella
  • Start date Start date
D

David Kinkella

Is it possible to copy and paste a conditional sum formula
to a different cell location and then change the = to
value in the IF( portion of the formula?

I can cut and paste without any problems. However, the
moment I start changing some the equal to values I destroy
the formula. I get a result of zero when the correct
result is some other value.

I need to copy and paste the conditional some formula and
then change the = value without having to go through the
windows process each time in order to save a tremendous
amount of time in a large worksheet that I am creating.

Regards,

David
 
Hi David,

If the formulas were created using the Conditional Sum
Wizzard, they are probably array formulas. Is the original
formula enclosed in squiggly brackets {}? If so, whenever
you edit this type of formula you must also re-enter it as
an array by holding down CTRL, SHIFT and then hit ENTER.

Something else you could do is to use a cell reference for
the equals to value. Put that value in a cell and refer to
that cell instead of the cells value.

Biff
 
Back
Top