| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding cells depending on a date
I have a spreadsheet with three sets of columns for each month going along
the top. I have actual figures, worst case and best case, with each column totalled at the bottom. At the far right (after December) I want a running total of all the actual totals based on a cell containing a month. So if the month cell is January the total cell will just equal the total cell for January, but if it's March then it will equal the sum of the January, February and March totals. Is there a simple way to do this without a huge formula with lots of IF statements? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding cells depending on a date
1. make sure that each month cell will contain zero or a blank until the data
for that month has been entered. 2. then make the sum of ALL months, future months will contribute zero, but that's o.k. -- Gary''s Student - gsnu200816 "Keith" wrote: I have a spreadsheet with three sets of columns for each month going along the top. I have actual figures, worst case and best case, with each column totalled at the bottom. At the far right (after December) I want a running total of all the actual totals based on a cell containing a month. So if the month cell is January the total cell will just equal the total cell for January, but if it's March then it will equal the sum of the January, February and March totals. Is there a simple way to do this without a huge formula with lots of IF statements? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding cells depending on a date
Thats no use. They want to input a whole years data then simply get a total
at any point in the year by simply inputing a month. "Gary''s Student" wrote: 1. make sure that each month cell will contain zero or a blank until the data for that month has been entered. 2. then make the sum of ALL months, future months will contribute zero, but that's o.k. -- Gary''s Student - gsnu200816 "Keith" wrote: I have a spreadsheet with three sets of columns for each month going along the top. I have actual figures, worst case and best case, with each column totalled at the bottom. At the far right (after December) I want a running total of all the actual totals based on a cell containing a month. So if the month cell is January the total cell will just equal the total cell for January, but if it's March then it will equal the sum of the January, February and March totals. Is there a simple way to do this without a huge formula with lots of IF statements? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding cells depending on a date
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add Cells in a row depending on Date | Excel Worksheet Functions | |||
| adding rows depending on cell value | Excel Worksheet Functions | |||
| adding specific cells based on a corresponding date | Excel Worksheet Functions | |||
| Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
| Adding sales depending on 2 Criteria | Excel Worksheet Functions | |||
Linear Mode
