Another way:

With my headings in row 2, and data in row 3, columns A to L, and a
column letter (a thru l) in cell M1, in cell M3, for the YTD total,
type:

=SUM(INDIRECT("A3:"&M1&"3"))

This will resolve to =sum(A3:X3) where x is the letter you type in M1.


I came up with this a long time before I learned about sumproduct,
which gives a more elegant solution.

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=528887