Hello,
I have daily data and want to convert it into weekly data by summing daily values. Doing it manually is very time consuming. Is there any formula that will help me to accomplish my task?
I have daily data given in the cells A1:A393. I want to have weekly data (i.e. sum of 7 daily values) in column B. How can that be done?
Regards,
Miranda
It is easier if you post a sheet, then we can see what you have and what you want, more easily. But... Is this close/
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Dear Glenn,
In your Excel file you exactly gave me the formula I wanted. So, I will simply apply it to my data. Since everything is clear, i will not post my file there.
Thank you so much!
Miranda
Miranda, you're very welcome.
If that's it - please mark the thread as solved and (preferably) click the add Reputation button at the foot of this post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks