Here’s the deal. I have a list of dates (column A) and dollar amounts (column B). On another sheet, I am wanting to use a vlookup to find a date in column A on the first sheet, and add up the corresponding dollar amount in column B, as well as the next 4 dollar amounts after that (i.e. the dollar amounts of the subsequent 4 dates). How do I do it?
This worked for me:
=SUM(INDIRECT(“B” & MATCH(D2,A2:A9,FALSE)+1 & “:B” & MATCH(D2,A2:A9,FALSE)+5))
This is with headers in row 1 and data starting in row 2.
How it works is left as an exercise for the student …