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? |
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? |
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? |
Adding cells depending on a date
|
All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com