alancyoung
New Member
- Joined
- Feb 29, 2008
- Messages
- 29
I hope someone can help me.
See table below.
<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>
</tbody>I am looking for a formula which will SUM Row 2011 in the YTD Column to give a value of 700 as shown. This is because, up until June 2011 the total was 700, which allows me to compare to the 800 value in 2012.
When I input July, I want the value in YTD 2011 to update too, which in this case would remain as 700 due to the 0 value in 2011.
Hope this makes sense and you are able to help.
Thanks
Alan
See table below.
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD | |
2011 | 100 | 100 | 0 | 100 | 200 | 200 | 0 | 100 | 100 | 200 | 100 | 100 | 700 |
2012 | 200 | 200 | 100 | 0 | 100 | 200 | 800 |
<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>
</tbody>
When I input July, I want the value in YTD 2011 to update too, which in this case would remain as 700 due to the 0 value in 2011.
Hope this makes sense and you are able to help.
Thanks
Alan