RE: Sum a range of columns ?

Giganews Newsgroups
Subject: RE: Sum a range of columns ?
Posted by:  Miguel Zapico
Date: Mon, 8 May 2006

You can use indirect for achieving this.  Suppose that we have the month data
in column B (B1:B12), and the cell where you want to enter the moving month
is C1.  You can enter this formula is C2, for example:
="B1:B" & C1
And then in B13 (or wherever fits)
=SUM(INDIRECT(C2))

Hope this helps,
Miguel.

"Ainsley" wrote:

>
> 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

In response to

Sum a range of columns ? posted by Ainsley on Mon, 8 May 2006