I'm trying to sum select cells in a column, say Column C based on the dates
in Column A if the date falls between two dates selected from cells in a
seperate sheet of the same work book. For example if my critera cells
contained the start date 10/01/08 and the end date 10/03/08 it would return
the total $1100

Ex. A B C D
DATE BATCH NAILS SCREWS
1 10/01/08 RED $100 $20
2 10/02/08 BLUE $200 $10
3 10/05/08 GREEN $400 $30
4 10/03/08 YELLOW $800 $05

TIA