Dynamic Total to Date.

[rcolving]

I need to write a formula that looks at a date entered in a field that does a lookup on a data sheet and adds totals from the beginning of our fiscal year through to existing date.

Example.
date entered is 11/30/2009.

Data sheet has monthly totals for
Jan - Nov 2009
Need calculation of totals from fiscal year start (July) through Nov.

When date entered is 9/30/2009
Need calculation of totals from fiscal year start (July) through Sep.

I've got a vlookup that can pull a single month total but not sure how to get total of more than one cell.

The formula I use for one month total is =VLOOKUP(G$7,'Data Sheet'!$A$2:$AC$122,2,TRUE)

Any help would be appreciated.

 

[Robert Mika]

Try this:

Array formula(confirm CTRL+SHIFT+ENTER)