YTD Totals and Variances

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 |
+-------------------------------------------------------------------+
 
A

Alex Delamain

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
 
Top