YTD Totals and Variances

  • Thread starter Thread starter Christine Wilso
  • Start date Start date
C

Christine Wilso

I have a spreadsheet which looks at the financial year for various
shops.
I want to add up the YTD sales for each of the shops and compare this
to the same time period last year. But I can't figure out how to sum
the April to September for last year.


+-------------------------------------------------------------------+
|Filename: Cumulative YTD Test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=2731 |
+-------------------------------------------------------------------+
 
Christine
Most people are reluctant to open attachments - can you give us an ide
of how the data is structured - especially relating to date columns (i
is every sale logged and if so do you have a date for each entry or i
it summarised by week or month etc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

YTD totals 1
Sumproduct and Sumif formulas 2
YTD calculation 3
Excel Getting an annualized figure based on YTD in Excel 1
Calculating YTD for 2004/05 & 2003/04 2
YTD total (6 months w/o each record having 6 entries) 2
YTD Totals 1
Help with Variable Ranges! 1

Back
Top