Dynamic Total to Date.

rcolving

Board Regular
Joined
May 23, 2002
Messages
119
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.
 

Forum statistics

Threads
1,082,478
Messages
5,365,783
Members
400,850
Latest member
Raj_Jpr

Some videos you may like

This Week's Hot Topics

Top