Calculating YTD & compare to same time last year

  • Thread starter Christine Wilso
  • Start date
C

Christine Wilso

I have a spreadsheet (LPT Data) which contains the following columns fo
the year 2004/05:
Area;Month;No of Sales;Rev;Close Date. (Columns A:E)
This is repeated in the adjacent columns to it for 2003/04. (Column
F:J)
The rows contain all the months from April to March (Financial Year)

A download from a database updates the figures each month end fo
2004/05, wheras 2003/04 is complete.

I have sumif formulas set up to find the monthly revenue on the mos
recent month, and work out the % difference to the same month las
year.
(D4-(SUMIF('LPT data'!$B$3:$B$14,'Global Info'!$B$16,'LP
data'!I3:I14)))/(SUMIF('LPT data'!$B$3:$B$14,'Global Info'!$B$16,'LP
data'!I3:I14))
[Where D4 is the current month's revenue, LPT data is where my data i
held, and Global Info is where the current month is entered]

How do I calculate the % difference for the year to date revenue? ie
April to Septembe
 
Top