Using IF function then Autofill-increments down a reference cell

[Twinspot]

After creating an IF function, when I attempt to autofill, the corresponding
filled cell increments the reference cell. Example:

Original cel
=IF(B2=Overstreet!C7,Overstreet!D7)+IF(B2:B495=Overstreet!C8,Overstreet!D8)+IF(B2:B495=Overstreet!C9,Overstreet!D9)+IF(B2:B495=Overstreet!C10,Overstreet!D10)+IF(B2:B495=Overstreet!D11,Overstreet!D11)+IF(B2:B495=Overstreet!C12,Overstreet!D12)+IF(B2:B495=Overstreet!C13,Overstreet!D14)+IF(B2:B495=Overstreet!C15,Overstreet!D15)+IF(B2:B495=Overstreet!C16,Overstreet!D16)

First autofilled cel
=IF(B3=Overstreet!C8,Overstreet!D8)+IF(B3:B496=Overstreet!C9,Overstreet!D9)+IF(B3:B496=Overstreet!C10,Overstreet!D10)+IF(B3:B496=Overstreet!C11,Overstreet!D11)+IF(B3:B496=Overstreet!D12,Overstreet!D12)+IF(B3:B496=Overstreet!C13,Overstreet!D13)+IF(B3:B496=Overstreet!C14,Overstreet!D15)+IF(B3:B496=Overstreet!C16,Overstreet!D16)+IF(B3:B496=Overstreet!C17,Overstreet!D17)

Secon
=IF(B4=Overstreet!C9,Overstreet!D9)+IF(B4:B497=Overstreet!C10,Overstreet!D10)+IF(B4:B497=Overstreet!C11,Overstreet!D11)+IF(B4:B497=Overstreet!C12,Overstreet!D12)+IF(B4:B497=Overstreet!D13,Overstreet!D13)+IF(B4:B497=Overstreet!C14,Overstreet!D14)+IF(B4:B497=Overstreet!C15,Overstreet!D16)+IF(B4:B497=Overstreet!C17,Overstreet!D17)+IF(B4:B497=Overstreet!C18,Overstreet!D18)

And so on. Any suggestions?

 

[Gav123]

Hi,

Make your cell reference absolute..

For example if your cell reference is B2 make it $B$2.

Hope this helps,

Gav.

 

[Twinspot]

Thanks Gav,

That solved my issue.
--
Mark

Hi,

Make your cell reference absolute..

For example if your cell reference is B2 make it $B$2.

Hope this helps,

Gav.