redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
HI all
Is there a formula that can populate the current months table with daily totals taking the data from a range?
so, I have a simple table with days 1-31 listed and I'd like the daily total from the current month populated into each day.
for example, the data table looks like this...
..and the output table like this.....
So if the current month was NOV (2013) , I'd like the daily total sales to be plaed in each of the day rows in the out put table using a formula..
In my examples above the result required would look like the following....
Hope this makes sense and appreciate in advance any help
Is there a formula that can populate the current months table with daily totals taking the data from a range?
so, I have a simple table with days 1-31 listed and I'd like the daily total from the current month populated into each day.
for example, the data table looks like this...
DATE | MONTH | Q | SALES |
01-Nov-13 | Nov | 3 | |
02-Nov-13 | Nov | 3 | 20 |
03-Nov-13 | Nov | 3 | |
04-Nov-13 | Nov | 3 | |
05-Nov-13 | Nov | 3 | 325 |
06-Nov-13 | Nov | 3 | 250 |
..and the output table like this.....
DAY | TOTALS |
1 | |
2 | |
3 | |
4 | |
5 | |
So if the current month was NOV (2013) , I'd like the daily total sales to be plaed in each of the day rows in the out put table using a formula..
In my examples above the result required would look like the following....
DAY | TOTALS |
1 | |
2 | 20 |
3 | |
4 | |
5 | 325 |
6 | 250 |
7 | |
Hope this makes sense and appreciate in advance any help