When I copy and Paste a conditional sum, why is it that it will give me a 0 value.
T Troy Oct 24, 2003 #1 When I copy and Paste a conditional sum, why is it that it will give me a 0 value.
C CLR Oct 24, 2003 #2 I would bet it's because the formula is written with Relative references rather than Absolute references......like A1 instead of $A$1......... Vaya con Dios, Chuck, CABGx3
I would bet it's because the formula is written with Relative references rather than Absolute references......like A1 instead of $A$1......... Vaya con Dios, Chuck, CABGx3
T Troy Oct 24, 2003 #3 This is true and it has be absolute or else conditional sum won't work. Is there any solution.
C CLR Oct 24, 2003 #4 Perhaps using RangeNames in your formula instead of directly coding in the cell references would help........ Vaya con Dios, Chuck, CABGx3
Perhaps using RangeNames in your formula instead of directly coding in the cell references would help........ Vaya con Dios, Chuck, CABGx3
