Ok, I have a Work Book with 3 Sheets. The first sheet at dates in Column A
(2-Feb-2007), the second has serial numbers and the third Column C has the
number of items on hand. What I am trying to do is if the serial number has a
date of a month (ie 1-Jan-2007) then i would like to sum the number of items
on hand for each month.
The first sheet currently looks like this
2-Feb-2007 37220 41
7-Feb-2007 37247 48
8-Feb-2007 37255 115
9-Feb-2007 37267 104


The data will be summed on the third sheet.

And should look like this.
Month # Serial # Items Selected
Jan
Feb
Mar
Ect..