If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy and Paste Conditional Sum Formula
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 |
#2
|
|||
|
|||
Copy and Paste Conditional Sum Formula
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 -----Original Message----- 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 . |
Thread Tools | |
Display Modes | |
|
|