Formula for running cumulative numbers with conditions to populate cells

[BDubbs]

I am currently working a spreadsheet where are would like to run comparisons of numbers this year vs last year. I have the monthly numbers for last year and obviously not yet for this year. How do I get the spreadsheet to populate last year's numbers only when I enter a number into the same month for this year.For example, if the Total for the year is $120,000 and each month has a revenue of $10 but this year, I am only inputting for January (soon). When the cummulative number compares to last year, by the end of February I may have $35,000 in revenue and want to only show a comparison to the $20,000 that I had last year but instead am showing the year total of $120,000. Thx

[DonkeyOte]

It would be a great deal easier if you could provide some range information - ie where the data for each fiscal is being stored.

In principle what you're trying to do is relatively straightforward - if we assume current year values will be stored in B2:B13 and prior year is in say D2:D13 then we can get a YTD comparison using:

Please Login or Register  to view this content.

the above assumes you would always enter a value for a prior month even if 0 and that future months (current fiscal) are blank.

[BDubbs]

Thank you for your info. I think that we are close. I didn't explain myself quite clearly. The numbers aren't TY vs LY actually, they are TY vs Budget. I have attached the rows as I see it in my spreadsheet.
The headings would start with the Total and then the second column would be January and so on. The top row is last year and the bottom row is this year.

[DonkeyOte]

As I said without ranges it's very difficult to provide anything meaningful.

From your image it's hard to decipher what you're doing given all values appear complete, however, if you're dealing with Horizontal Vectors as opposed to Vertical simply adjust the references in the example accordingly
(ie from B2:B13 to B2:M2 etc...)

If you need help with an Excel file it's best to post an Excel file - images are of limited use (unless you need help with an image of course)