Is there a way to carry a formula down cells and have only part of the
formula change. Need to reference the cell next to it, but not the
lookup formula. need to keep column C from changing, but need to have
B Cell Reference change, as I drop formula down.

I have 60-80 cells, and this get tedious.

=SUMPRODUCT(--EXACT('3-2007'!C1:C551,B54))+SUMPRODUCT(--EXACT('2-2007'!
C1:C551,B54))+SUMPRODUCT(--EXACT('1-2007'!C1:C551,B54))+SUMPRODUCT(--
EXACT('12-2006'!C1:C551,B54))

Thanks in advance.