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?

Change the sum range references to absolute, such as A1 to $A$1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top