Copy Paste Troubles :-(

[blues_sender2]

Hello all,
I have a small problem, which I just can't seem to fix, so if one o
you guys can help me, it will be great
Here are the details:
I have a sum if condition:
SUMIF(A1:A1000,C1,B1:B1000)
(i.e, sum every Bi that has Ai=C1).
Now I want to drag it 999 times, meaning that the following lines wil
look like this:
SUMIF(A1:A1000,C2,B1:B1000)
SUMIF(A1:A1000,C3,B1:B1000)
SUMIF(A1:A1000,C4,B1:B1000)

The problem is when I drag it, the range changes too, which I don'
want. Meaning, when I drag it, it seems something like :
SUMIF(A2:A1001,C2,B2:B1001)
SUMIF(A3:A1002,C2,B3:B1002)

The solution is probably short, can you help me please?
many thank

 

[Alan]

Working for the Yankee Dollar! Look up Absolute or Relative in Help,

SUMIF($A$1:$A$1000,C1,$B$1:$B$1000)

Regards

 

[Frank Kabel]

Hi
try
SUMIF($A$1:$A$1000,C1,$B$1:$B$1000)

and also have a look at:
http://www.cpearson.com/excel/relative.htm

 

[blues_sender2]

Wow..that was fast
bless you and your family
:-