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

[Guest]

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.

 

[Ragdyer]

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.

 

[Guest]

Thanks for this. Will give it a go.

Kind regards