I have a worksheet(1) that is setup as follows:
Col A ColB ColC
Item# Date Qty

Worksheet(2)
ColA ColB ColC ColD
Item# Start Date End Date (result)

I am trying to write a function that will look for info in cell A5 in
worksheet 2 and find the info in column A in worksheet 1 check that the date
in column B being between a date range and then returning a sum of the totals
of the corresponding rows of column C in worksheet 1. I hope this makes
sense..I'm not sure how else to explain it.
--
narp