Copying SumIF formulas without changing the Sum Range

D

Deborah

I am having trouble copying a SumIf formula without the
Sum Range changing. Does anyone know how to do this?
 
P

Paul

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.
 
Top