JE McGimpsey Wrote:
One way:

Say this is entered in column A:

=SUM(OFFSET('Enrollment Data'!$H$15,COLUMN()-COLUMN($A:$A),0,1,5))


If it's entered in a different column, change $A:$A to that column
reference

Uhmm this works. I have no idea why. I don't get it. How is that
working?


--
jckurk
------------------------------------------------------------------------
jckurk's Profile: http://www.excelforum.com/member.php...o&userid=24152
View this thread: http://www.excelforum.com/showthread...hreadid=377777