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!!!!!!!!!!
+-------------------------------------------------------------------+
|Filename: Capture.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4175 |
+-------------------------------------------------------------------+
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 |
+-------------------------------------------------------------------+