a cummulative or to-date total based on time and metrics

's Computer Specifications

example:
A B C D
E F
JAN FEB MARCH Q1
TOTAL YEAR-TO-DATE

1
PLAN 100 200 300 600
2 FORECAST 120 210 330

3 ACTUAL 120 200
320

It is currently feb 20th and I am forecasting feb only and have actuals
for feb only...not march but i have my plan locked in for the year.
I want to be able to calculate plan-to-date in the year to date column
which would be jan and feb only so I can see the relationship between
actual, forecast and plan-to-date. I am looking for a formula that
will give me a "to-date" total based on current point in time and
exclude future months.

so year-to-date plan should come out to 300 and exclude march if it is
currently still february.
Does this make sense? I have tried if, then arguements but have bene
unsucessful. I am stuck.

any help on this would be greatly appreciated.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I get a cummulative total in excel	luvkoffee	Microsoft Excel Misc	1	6th Jan 2010 11:47 PM
Cummulative total in Userform	=?Utf-8?B?THVpc0U=?=	Microsoft Excel Programming	4	29th Aug 2007 12:32 AM
to-date total based on current date	dreamkeeper	Microsoft Excel Worksheet Functions	3	10th Aug 2006 09:33 PM
a cummulative or to-date total based on time and metrics	dreamkeeper	Microsoft Excel Discussion	0	9th Aug 2006 06:14 AM
Getting a cummulative total from a one-to-many	Ted Allen	Microsoft Access Queries	0	11th Mar 2004 04:04 PM