# Using IF function then Autofill-increments down a reference cell

T

#### 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?

Hi,

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

Hope this helps,

Gav.

Thanks Gav,

That solved my issue.
--
Mark

Gav123 said:
Hi,