Copy Paste Troubles :-(

B

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
 
A

Alan

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

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

Regards
 
Top