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


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