I have a spreasheet that contains data for 3 years

Jan 2006 Jan 2007 Jan 2008
50 50 0

Etc. Etc

All the months are populated for 2006 & 2007

But 2008 only has cells populate to June

I would like to sum only the rows for 2006 & 2007 up to the same YTD as 2008

The columns are there for 2008 there are just no numbers populated.

Is this possible?

=SUM(A1:INDEX(A1:A12,MONTH(TODAY())))

and so on

--
__________________________________
HTH

Bob

"phuser" wrote in message
el...
I have a spreasheet that contains data for 3 years

Jan 2006 Jan 2007 Jan 2008
50 50 0

Etc. Etc

All the months are populated for 2006 & 2007

But 2008 only has cells populate to June

I would like to sum only the rows for 2006 & 2007 up to the same YTD as
2008

The columns are there for 2008 there are just no numbers populated.

Is this possible?

I'm not really sure what you want. Do you want a sum at the bottom of
each column which will only show up to the same month as the latest in
the current year? Or do you want a single sum for 2006 and another sum
for 2007 which will only take into account the months up to the
current? How many items do you have in each column? Where do you want
the sums to go (which cells)?

Please give further details.

Pete

On Jun 24, 11:15*pm, "phuser" wrote:
I have a spreasheet that contains data for 3 years

Jan 2006 * *Jan 2007 Jan 2008
50 * * * * * * * *50 * * * * * *0

Etc. Etc

All the months are populated for 2006 & 2007

But 2008 only has cells populate to June

I would like to sum only the rows for 2006 & 2007 up to the same YTD as 2008

The columns are there for 2008 there are just no numbers populated.

Is this possible?