Monthly to Quarterly Cash Flows

[realvirtuality1]

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

[Ron Coderre]

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)

Please Login or Register  to view this content.

EDITED TO INCLUDE THIS ALTERNATIVE:

Please Login or Register  to view this content.

Is that something you can work with?

[realvirtuality1]

Yes! Thanks!