How do I get excel to "count" cells along a row?
 

I hope I can make this make sense. I am sure the answer is very simple as
every spreadsheet that underpins a budget must allow for flexible forecasting.

I am trying to create a spreadsheet that allows me to start calculations
anywhere on a time line and allows me to change the amount of time that the
calculations will last. For example, if I am looking at a 12 month time line
(Jan to Dec) then I want to be able to start a function in any month and then
for that function to last for any amount of time. So the first function may
start in Jan and last for three months. In parallel a second function may
start in Jan and last for five months and then a third function may start in
Feb and last for two months.

How do I set up a sheet so that when a function starts, the sheet know to
mark each cell on the time line that relates to the amount of time that the
function will last.

Confused? I am...and therefore in need of help.

Is something like this what you're talking about:

A1:A100 = dates
B1:B100 = numeric values ($'s, widgets)

Enter start date of query in C1,
Enter end date of query in D1

Try this formula:

=SUMPRODUCT((A1:A100=C1)*(A1:A100<=D1)*B1:B100)

Dates must be "true" XL dates.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"ebnc92" wrote in message
...
I hope I can make this make sense. I am sure the answer is very simple as
every spreadsheet that underpins a budget must allow for flexible
forecasting.

I am trying to create a spreadsheet that allows me to start calculations
anywhere on a time line and allows me to change the amount of time that
the
calculations will last. For example, if I am looking at a 12 month time
line
(Jan to Dec) then I want to be able to start a function in any month and
then
for that function to last for any amount of time. So the first function
may
start in Jan and last for three months. In parallel a second function may
start in Jan and last for five months and then a third function may start
in
Feb and last for two months.

How do I set up a sheet so that when a function starts, the sheet know to
mark each cell on the time line that relates to the amount of time that
the
function will last.

Confused? I am...and therefore in need of help.

Thanks for this. Will give it a go.

Kind regards

"Ragdyer" wrote:

Is something like this what you're talking about:

A1:A100 = dates
B1:B100 = numeric values ($'s, widgets)

Enter start date of query in C1,
Enter end date of query in D1

Try this formula:

=SUMPRODUCT((A1:A100=C1)*(A1:A100<=D1)*B1:B100)

Dates must be "true" XL dates.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"ebnc92" wrote in message
...
I hope I can make this make sense. I am sure the answer is very simple as
every spreadsheet that underpins a budget must allow for flexible
forecasting.

I am trying to create a spreadsheet that allows me to start calculations
anywhere on a time line and allows me to change the amount of time that
the
calculations will last. For example, if I am looking at a 12 month time
line
(Jan to Dec) then I want to be able to start a function in any month and
then
for that function to last for any amount of time. So the first function
may
start in Jan and last for three months. In parallel a second function may
start in Jan and last for five months and then a third function may start
in
Feb and last for two months.

How do I set up a sheet so that when a function starts, the sheet know to
mark each cell on the time line that relates to the amount of time that
the
function will last.

Confused? I am...and therefore in need of help.