Hi,
Example file is attached.
The 1st row indicates year&month.
In 2nd row, column A indicates effective year&month; and the rest columns are quantity per each month.
I would like to sum the quantity based on column A value.
say, the effective year and month is 202311 and I would like to sum of next 12 months only in Column W - that is, between 202311 and 202410.
How can I achieve this?
I tried with sumifs function but could not make it happen.
tRY:
=SUM(INDEX(2:2,,MATCH(A2,1:1,0)):INDEX(2:2,,MATCH(A2,1:1,0)+11))
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
X2=sumproduct((text(b1:v1&"01"+0,"0000-00-0")+0>=(text(a2&"01"+0,"0000-00-0")+0))*(text(b1:v1&"01"+0,"0000-00-0")+0<=edate(text(a2&"01"+0,"0000-00-0")+0,11))*(b2:v2))
Last edited by CARACALLA; 12-01-2023 at 10:08 AM.
Another solution:Formula:
Please Login or Register to view this content.
Thank you all, perfect
You're welcome. Thanks for letting us know that you got an answer.
Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks