Sum which starts from Specific Date range

[lalro143]

Hi,

I have a data as shown below, Now I need sum starts from month shown in column 1

[TABLE="width: 384"]
<colgroup><col width="64" style="width: 48pt;" span="8"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"] [/TD]
[TD="width: 64, bgcolor: transparent"]Jan-09[/TD]
[TD="width: 64, bgcolor: transparent"]Feb-09[/TD]
[TD="width: 64, bgcolor: transparent"]Mar-09[/TD]
[TD="width: 64, bgcolor: transparent"]Apr-09[/TD]
[TD="width: 64, bgcolor: transparent"]May-09[/TD]
[TD="width: 64, bgcolor: transparent"]Jun-09[/TD]
[TD="width: 64, bgcolor: transparent"]Total[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Month[/TD]
[TD="bgcolor: transparent"]Amount[/TD]
[TD="bgcolor: transparent"]Amount[/TD]
[TD="bgcolor: transparent"]Amount[/TD]
[TD="bgcolor: transparent"]Amount[/TD]
[TD="bgcolor: transparent"]Amount[/TD]
[TD="bgcolor: transparent"]Amount[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Jan-09[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]2[/TD]
[TD="bgcolor: transparent"]3[/TD]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"]5[/TD]
[TD="bgcolor: transparent"]6[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feb-09[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]2[/TD]
[TD="bgcolor: transparent"]3[/TD]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"]5[/TD]
[TD="bgcolor: transparent"]6[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]May-10[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]2[/TD]
[TD="bgcolor: transparent"]3[/TD]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"]5[/TD]
[TD="bgcolor: transparent"]6[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Mar-09[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]2[/TD]
[TD="bgcolor: transparent"]3[/TD]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"]5[/TD]
[TD="bgcolor: transparent"]6[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

E.g. Jan-09 includes sum starts from Jan-09 to Jun-09=21
Feb-09 includes sum starts from feb-09 to Jun-09=20
May-09 includes sum starts from may-09 to Jun-09=11

Thank in advance.

 

[pgc01]

Hi

Why are the numbers in all the rows repeated?
Is it always like that (in that case why repeat them?) ?

 

[Special-K99]

More to the point why are column headers the same as the row headers

 

[spoon_db]

Insert a row and column for index numbers which represent the month... If you want, you can include the date too...

Array formula: =SUM(IF($C$2:$H$2>=B4;C4:H4))

[TABLE="width: 720"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Jan-09[/TD]
[TD]Feb-09[/TD]
[TD]Mar-09[/TD]
[TD]Apr-09[/TD]
[TD]May-09[/TD]
[TD]Jun-09[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]index[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Month[/TD]
[TD][/TD]
[TD]Amount[/TD]
[TD]Amount[/TD]
[TD]Amount[/TD]
[TD]Amount[/TD]
[TD]Amount[/TD]
[TD]Amount[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jan-09[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Feb-09[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]May-10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Mar-09[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]18[/TD]
[/TR]
</tbody>[/TABLE]

 

[lalro143]

Hi,

I put these as examples to get more clarity however numbers are different in actual.

The above array formula is not working.

Please suggest

 

[lalro143]

Thanks I got it. Its working now

I have removed the ; from the formula.

Thanks a lot.