[TABLE="width: 2106"]
<colgroup><col span="24"><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I need to some help to sum the coloums from month to calulcate the Year to date, the problem is I have two type of columnes I need to sum [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 2106"]
<colgroup><col span="24"><col><col><col><col></colgroup><tbody></tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Apr[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Apr[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]May[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]May[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jun[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jun[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jul[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jul[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Aug[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Aug[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Sep[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Sep[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Oct[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Oct[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Nov[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Nov[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Dec[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Dec[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jan[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jan[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Feb[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Feb[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Mar[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Mar[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]YTD[/TD]
[TD]YTD[/TD]
[/TR]
[TR]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[TD="class: xl73, width: 79"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"][/TD]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Achieved[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Achieved[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Achieved[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]15 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 72.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
</body>So I want a foumala that would sum the YTD target if I select May , it would sum Apr to May. The Same for achieved.
Any help would be much appreicated.
Thank you
Wes
<colgroup><col span="24"><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]I need to some help to sum the coloums from month to calulcate the Year to date, the problem is I have two type of columnes I need to sum [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 2106"]
<colgroup><col span="24"><col><col><col><col></colgroup><tbody></tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Apr[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Apr[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]May[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]May[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jun[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jun[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jul[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jul[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Aug[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Aug[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Sep[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Sep[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Oct[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Oct[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Nov[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Nov[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Dec[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Dec[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jan[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Jan[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Feb[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Feb[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Mar[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="colspan: 2"]Mar[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]YTD[/TD]
[TD]YTD[/TD]
[/TR]
[TR]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[TD="class: xl73, width: 79"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"][/TD]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Achieved[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Achieved[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Achieved[/TD]
[TD][TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Target[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Target[/TD]
[TD]
[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]15 [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 72.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 158"]
<tbody>[TR]
[TD="class: xl73, width: 79"]Achieved[/TD]
[/TR]
</tbody>[/TABLE]
</body>So I want a foumala that would sum the YTD target if I select May , it would sum Apr to May. The Same for achieved.
Any help would be much appreicated.
Thank you
Wes