D Deborah Oct 9, 2003 #1 I am having trouble copying a SumIf formula without the Sum Range changing. Does anyone know how to do this?
I am having trouble copying a SumIf formula without the Sum Range changing. Does anyone know how to do this?
P Paul Oct 9, 2003 #2 Deborah said: I am having trouble copying a SumIf formula without the Sum Range changing. Does anyone know how to do this? Click to expand... Change the sum range references to absolute, such as A1 to $A$1.
Deborah said: I am having trouble copying a SumIf formula without the Sum Range changing. Does anyone know how to do this? Click to expand... Change the sum range references to absolute, such as A1 to $A$1.
