Paste formula every nth row
 

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
------------------------------------------------------------------------
edinclimb's Profile: http://www.excelforum.com/member.php...o&userid=30065
View this thread: http://www.excelforum.com/showthread...hreadid=497456

Paste formula every nth row
 

"edinclimb" wrote
in message ...

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.