Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count shaded cells | Excel Worksheet Functions | |||
How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) | |||
How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
COUNT ONLY CELLS THAT AREN'T BLANK | Excel Worksheet Functions | |||
Count cells with data | New Users to Excel |