Fill Down Help

[eckert1961]

Hello,

I have the following formula that I want to fill down in one column.

=IF(Sheet1!I3="Cost",(SUMPRODUCT(--(MONTH(Sheet1!$J$6:$J$1000)&YEAR(Sheet1!$J$6:$J$1000)=MONTH(A2)&YEAR(A2)), Sheet1!$I$6:$I$1000)),
(SUMPRODUCT(--(MONTH(Sheet1!$K$6:$K$1000)&YEAR(Sheet1!$K$6:$K$1000)=MONTH(A2)&YEAR(A2)), Sheet1!$J$6:$J$1000)))

When I fill down, Sheet1!I3 and the cell reference in MONTH(A2)&YEAR(A2)) increments. I only want the cell reference in MONTH(A2)&YEAR(A2)) to change. Is there a way to do this?

Thanks,
Chris

 

[Jonmo1]

Change
Sheet1!I3
to
Sheet1!I$3

 

[VoG]

Try

=IF(Sheet1!I$3="Cost",(SUMPRODUCT(--(MONTH(Sheet1!$J$6:$J$1000)&YEAR(Sheet1!$J$6:$J$1000)=MONTH(A2)&YEAR(A2)), Sheet1!$I$6:$I$1000)),
(SUMPRODUCT(--(MONTH(Sheet1!$K$6:$K$1000)&YEAR(Sheet1!$K$6:$K$1000)=MONTH(A2)&YEAR(A2)), Sheet1!$J$6:$J$1000)))

 

[eckert1961]

Hello,

That worked perfectly. Thanks for the quick responses.

Regards,
Chris