Summation Problem

[Simba1]

Hello Guys,

I work at a company who's fiscal year runs from December to November. I've been buildilng a spreadsheet for over a month now, and am stuck at one particular spot.

To simplify everything, I have a table that is populated by a User Form. The table has the dates on the left most column as follows:

Mar-05
Apr-05
May-05
Jun-05
Jul-05
Aug-05
Sep-05
Nov-05
Dec-05
Jan-06
Feb-06

Now these dates are dependant on what the user might enter into the form. The user entered Mar-05 which is why the example above begins in March-05. If the user entered May-05, it would have started with May-05 and ended with Apr-06.

I have a column next to the date column that has the sales info for the month. This value is looked up. Below the chart, I simply use a simple sum function to get the total sales. However, I've have been killing myself for the past hour trying to figure out how to calculate the Fiscal 05 sales. In the example above, that would be the sales from Mar-05 to Nov-05. I can enter this in manually, but was wondering if there was a formula I could use to avoid this.

Any help?

 

[Aladin Akyurek]

Thats right Aladin

Fiscal 2005 would be Dec 2004 to Nov 2005
Fiscal 2006 would be Dec 2005 to Nov 2006

and so on...

You have any ideas?

Just curious: What would be the sum for Fiscal 2005 wrt the sample you posted, $1,059,926 maybe?