Is there a way to use Vlookup but have it return the sum of multiple cells. For instance if you had Jan, Feb, March, etc in A1:A12, with corresponding cash flows in B1:B12, I want my lookup formula to look for a month, say March, but return the sum of the values in the 2 months leading up to March as well (B1:B3) rather than just return the value in cell B3.
Is that possible? Thanks
Using your posted scenario
and
D1: a month....Nov
This formula returns the total for the 3 months ending with that month (if the month is Jan of Feb, the formula sums the available months)
EDITED TO INCLUDE THIS ALTERNATIVE:
E1: =SUM(INDEX(B1:B12,MAX(MATCH(D1,A1:A12,0)-2,1)):INDEX(B1:B12,MATCH(D1,A1:A12,0)))
Is that something you can work with?E1: =SUMPRODUCT((ROW(B1:B12)=MATCH(D1,A1:A12,0)-{0,1,2})*B1:B12)
Last edited by Ron Coderre; 06-24-2015 at 11:32 AM.
Yes! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks