Hi there,
I have a sumIF lookup adding tabs in another worksheet called 2006
Production Grid.

SUMIF('[2006 Production Grid 8.01.06.xls]Q1'!$A:$A,$B11,'[2006
Production Grid 8.01.06.xls]Q1'!I:I)+SUMIF('[2006 Production Grid
8.01.06.xls]Q2'!$A:$A,$B11,'[2006 Production Grid
8.01.06.xls]Q2'!I:I)+SUMIF('[2006 Production Grid
8.01.06.xls]Q3'!$A:$A,$B11,'[2006 Production Grid
8.01.06.xls]Q3'!I:I)+SUMIF('[2006 Production Grid
8.01.06.xls]Q4'!$A:$A,$B11,'[2006 Production Grid 8.01.06.xls]Q4'!I:I)

Unfortunately, the title of the Production Grid changes constantly to
reflect the date, so I need to update links and update the name of the
sheet for my formulas to work.

When I do this, all of my lookup formulas except my sumIF work. SumIF
only works if the Production Grid document is open.

Any idea why?
Jill


--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: http://www.excelforum.com/member.php...fo&userid=9498
View this thread: http://www.excelforum.com/showthread...hreadid=567115