jbenfleming
New Member
- Joined
- Mar 30, 2017
- Messages
- 34
I have two columns, one with dates and one with values. Such as:
<tbody>
</tbody>
In a separate cell I want to sum up the first week, i.e. =sum(b1:b7). I want to fill that formula down one row to capture the second week. But of course if I fill down one row it will change the formula to =sum(b2:b8) rather than my desired value, =sum(b8:b14). Any ideas on how to approach this?
8/4/19 | 1 |
8/5/19 | 5 |
8/6/19 | 4 |
8/7/19 | 4 |
8/8/19 | 7 |
8/9/19 | 4 |
8/10/19 | 4 |
8/11/19 | 4 |
8/12/19 | 3 |
8/13/19 | 4 |
8/14/19 | 3 |
8/15/19 | 2 |
8/16/19 | 4 |
8/17/19 | 4 |
<tbody>
</tbody>
In a separate cell I want to sum up the first week, i.e. =sum(b1:b7). I want to fill that formula down one row to capture the second week. But of course if I fill down one row it will change the formula to =sum(b2:b8) rather than my desired value, =sum(b8:b14). Any ideas on how to approach this?
Last edited: