I have got a list of dates and corresponding to them a numeric value. I want to find the sum of individual weeks from the list. Please see the worksheet below. thanks
I have got a list of dates and corresponding to them a numeric value. I want to find the sum of individual weeks from the list. Please see the worksheet below. thanks
Last edited by Sarangsood; 07-25-2013 at 12:53 AM.
This one explains better
1 way would be to use a helper column (I used C, you can hide it if you want), and then use this copied down...
=WEEKNUM(A1)
Then to get your totals...
=SUMIF($D$1:$D$25,ROW(A1),$C$1:$C$25)
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
In H1 Cell
Formula:Please Login or Register to view this content.
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
thanks a lot. both the suggestions are perfect.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks