changing and constant variables in a formula

[Drew]

I have a formula that reads =SUMIF(B11:B467,B479,D11467)

I want B11:B467 and D11467 to remain the same in the formula, but
want B479 to become B480, B481, B482, etc. as I move down the cells i
the column. I cannot figure out how to do this. If I write th
formula in one cell, then drag it down, all the numbers change...


Thanks in advance for any help anyone can give me...


Dre

 

[Andy B]

Hi

You need to use absolute references:
=SUMIF($B$11:$B$467,B479,$D$11:$D$467)

 

[Jason Morin]

To "freeze" references, place $'s before the column letter
and row number. The quickest way is to select the range in
the formula and continue pressing F4 until you get what
you want.

=SUMIF($B$11:$B$467,B479,$D$11:$D$467)

HTH
Jason
Atlanta, GA

 

[Drew]

THANK YOU!!! Works perfect!!

 

[Hans]

Change B11:B467 and D11467 to $B$11:$B$467 and
$D$11:$D$467.

regards