LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 148
Default Help with year to date comparison

Hello,

I have 2 sheets, one for 2008 and other for 2009. On each sheet I have
monthly data ($) and a cell with the sum of all the months. On the 2009 sheet
I will add a new figure monthly and this will add up the year total cell.
next to this one there is a year to date 2008 for comparison. So what I need
is that everytime that I type a number in a month on 2009, the year to date
2008 adds the same months... here the sample for better understanding...

2008
Revenue (USD)JUN JUL AUG SEPT OCT NOV DEC YTD 08 YTD 07
money 5 8 2 7 5 1 2 30 25

2009
Revenue (USD)JUN JUL AUG SEPT OCT NOV DEC YTD 09 YTD 08
money 5 6 4 15 15*

YTD= year to date
(*)Is there a formula that on YTD 08 adds the same months that already
contain data on 2009 extracting that data from 2008?? and doest it everytime
I add a number on a month in 2009?
thanks
please help!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determine year over year date for comparison zeroscou Excel Worksheet Functions 3 March 6th 09 10:01 PM
Monthly Comparison By Year Jerry[_7_] Charts and Charting in Excel 2 July 10th 08 12:45 PM
Date comparison TomD Excel Discussion (Misc queries) 4 February 20th 07 10:37 PM
Year-to-date year to date formula Philm Excel Worksheet Functions 1 October 7th 05 02:50 AM
Showing data per month & year for comparison gman Excel Discussion (Misc queries) 3 September 7th 05 01:23 AM


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"