Paste formula every nth row

  • Thread starter Thread starter edinclimb
  • Start date Start date
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 |
+-------------------------------------------------------------------+
 
edinclimb said:
Hi,

I have a problem trying to paste a formula every 7th row for a sum
value of each week.
Click to expand...

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.
 
Back
Top