Sum a range of columns ?

Giganews Newsgroups
Subject: Sum a range of columns ?
Posted by:  Ainsley (Ainsley.27hsmy_1147097701.224@excelforum-nospam.com)
Date: Mon, 8 May 2006

I have a simple budget with columns for each month (month 1 to 12) and a
Year to Date column at the end.

If it is now say month 3, how do I get my YTD column to just add up the
first three columns.  I have a cell that tells me what month we are in,
so I can use this in the formula, but I cant think of how to write the
formula that adds up this specified number of columns.

I want somthing that says it is now month 'x', so add up months 1 to
'x'.  Each time I put in the month number, I want to see the YTD sum
without changing that formula.

Any help will be appreciated.

Regards, AB

--
Ainsley
------------------------------------------------------------------------
Ainsley's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=31960
View this thread:http://www.excelforum.com/showthread.php?threadid=539848

Replies