Copying down sum formula with non equal ranges

jbenfleming

New Member
Joined
Mar 30, 2017
Messages
34
I have two columns, one with dates and one with values. Such as:

8/4/191
8/5/195
8/6/194
8/7/194
8/8/197
8/9/194
8/10/194
8/11/194
8/12/193
8/13/194
8/14/193
8/15/192
8/16/194
8/17/194

<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:

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Excel Workbook
ABC
18/4/2019129
28/5/2019524
38/6/20194
48/7/20194
58/8/20197
68/9/20194
78/10/20194
88/11/20194
98/12/20193
108/13/20194
118/14/20193
128/15/20192
138/16/20194
148/17/20194
Sheet2
 
Upvote 0

Forum statistics

Threads
1,213,486
Messages
6,113,932
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top