Paste formula every nth row


E

edinclimb

Hi,

I have a problem trying to paste a formula every 7th row for a sum
value of each week. to simplify say monday to sunday of 1 week had a
value of 1 - i want to total that value of 7 in a new column on the
sunday. for the next week say every day had a value of 2, on the sunday
in the new column i want a value of 14 to display.

To further confuse myself i need to total the sum of monthly data and
yearly data, I have attached a screen grab of my sheet for reference.

Please help!!!!!!!!!! :eek:


+-------------------------------------------------------------------+
|Filename: Capture.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4175 |
+-------------------------------------------------------------------+
 
Ad

Advertisements

T

teepee

edinclimb said:
Hi,

I have a problem trying to paste a formula every 7th row for a sum
value of each week.
You could put numbers 1 to 1000 in an adjacent column (assuming for the
sake of argument that 1000 is the depth of the column with the data you
want to separate out) and then copy and paste that 1 to 1000 seven times so
it's precisely seven times longer than your data column. Then do a sort on
it. Voila.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top