- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- RE: Sum a range of columns ?

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

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

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