Posted by mcarter973 on August 09, 2001 11:26 AM
I'm using a table to lookup values on a monthly basis.
column A: January, February, March, etc.
column B: Quantity (cell B13 is the YTD figure).
I want to create a formula that will lookup the month in column A and sum the YTD numbers in column B.
If I look up February I want to sum just January and February (8 and 10).