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...