Hi, thanks for that. Ive used it but cant get it to work exactly all
situations.

If my data starts in Column E (for Jan) and ends in Column P (Dec) and
the YTD is in Column T and the month number in Column V I cant seem to
make the formula work. The data all starts on row 11.

I also cant seem to copy it to other rows downward.

Ive typed
=SUM(INDIRECT("E"& ROW(E11) & ":" &ADDRESS(ROW(E11),$V$11)))

But its not working. What am i doing wrong ?


--
Ainsley
------------------------------------------------------------------------
Ainsley's Profile: http://www.excelforum.com/member.php...o&userid=31960
View this thread: http://www.excelforum.com/showthread...hreadid=539848