Hello
I have the following in a workbook and i am wanting the values in column C to be caluculated by a formula. So the formula will look to see if the date has changed from the cell above, if it is and the cell below is different it will add all those with the same date together, if not nothing (or a zero) will be entered.
Thanks in advance
I have the following in a workbook and i am wanting the values in column C to be caluculated by a formula. So the formula will look to see if the date has changed from the cell above, if it is and the cell below is different it will add all those with the same date together, if not nothing (or a zero) will be entered.
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
25 | Day | Value | DailyTotal | |||
26 | 01-Sep | 1 | ||||
27 | 01-Sep | 2 | ||||
28 | 01-Sep | 3 | 6 | |||
29 | 02-Sep | 4 | ||||
30 | 02-Sep | 5 | 9 | |||
31 | 03-Sep | 6 | 6 | |||
Sheet1 |
Thanks in advance