I want the formula to return the sum of return of T-1, T+0, T+1 (lookup column referring to column A in the '1636' tab, please ignore column B)based on the announcement date in the summary page (e.g. return sum of S979:S981 in '1636' tab)
Note: there are 200 similar tabs as '1636'. I think indirect function would help but I don't know how.
Test.xlsx
Last edited by ily4everrrrr; 11-10-2022 at 09:18 AM.
Administrative Note:
Attach the workbook to your original thread.
Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.
Please see Forum Rule #5 about thread duplication.
I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-the-data.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks