How to call a portion of the formula string in a different cell in current cell?

Here's what I'm trying to do. I have data I'm entering on a daily basis, say in column A, and I'm trying to analyze weekly trends, say in column B. I have a cell, say it's B1, that sums data from week 1 (A1:A7) as follows:

B1: =sum(A1:A7)

I want to be able to enter a formula in B2 that sums the data for week 2 (A8:A14), and I want this formula to be able to use the formula entered in B1 in order to determine what cells to sum. i.e.:

B2: =sum('last cell referenced in B1 + 1':'last cell referenced in B1 + 7')

This would then allow me to simply copy the formula down to analyze every week, instead of needing to retype '=sum(A#:A##)' every time. Is there a way to do this?


Thanks for any help with this!

Try this in B1 and drag down.

Please Login or Register  to view this content.

Ford

Thank you for your reply. I'm not quite sure how to use sumifs() in this case, but was able to solve my query with the formula below so am all good now.

K

kvsrinivasamurthy,

That formula worked perfectly! Thank you very much for your help here.

K