Apart from the fact that this sums all values between say F12 and L12, where
the OP only wants every 3rd column (at least in the example), it does have
the limitation of being volatile. Maybe a problem, maybe not, but it is a
consideration.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mikeopolo" wrote
in message ...

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