Hi, hoping someone can help me.
I would like to be able to autosum every three months based on the month selected. For example if September it should automatically sum July, August and September and if the month changes to October it would sum August, September and October.
I want to be able to show a three-month trend depending on month selected. Are there any formulas that can help me do this?
I have attached example file with the way the data is setup.
Thanks in advance.
Solution deleted, it doesnt work
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Just for clarification, what you should the result be if July or August are selected?
BSB
@BadlySpelledBoy: I wondered that at first. I guess it would have to be just those months since there's no data for anything prior
This works
=SUMPRODUCT((COLUMN(B6:M6)-1>=MATCH(A5,B6:M6,0)-2)*(COLUMN(B6:M6)-1<=MATCH(A5,B6:M6,0))*(B7:M7))
...another option
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Both worked!!!! Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks