I need to calculate a YTD number from week 1 until the week selected from a drop-down list. If the week selected is 3, then the YTD from week 1 to week 3. If the week selected is week 4, then the YTD from week 1 to 4. I have attached a sample file.
Thanks in advance.
See if this is what you're up to.
I solved it with sumproduct.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
In G3 use..
=SUMIFS($C:$C,$B:$B,E3,$A:$A,"<="&$F$2)
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks very much. Works perfectly & I learnt something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks