Is there a way to convert this formula to sum a range instead of the single column?
=VLOOKUP("Production Total",Input!$A$6:$AK$195,$M$3+1,FALSE)
$M$3 is a number generated based on the selection from a pull down box. If you select a date (10/4/06) from the Pull Down List, cell M$3$ returns "4", so the VLOOKUP Formula then looks in Column 5 and returns the "Production Total" for that day.
What I'm trying to do is have a pull down box by Week instead of by Day. So If I select Week 1, the formula returns the Sum of the "Production Total" from Column 2 thru 8 (10/1/06 - 10/7/06).
=VLOOKUP("Production Total",Input!$A$6:$AK$195,$M$3+1,FALSE)
$M$3 is a number generated based on the selection from a pull down box. If you select a date (10/4/06) from the Pull Down List, cell M$3$ returns "4", so the VLOOKUP Formula then looks in Column 5 and returns the "Production Total" for that day.
What I'm trying to do is have a pull down box by Week instead of by Day. So If I select Week 1, the formula returns the Sum of the "Production Total" from Column 2 thru 8 (10/1/06 - 10/7/06).