I am making a new workbook to collect sums and counts from several other
archived workbooks, based on the date.

My archives have sheet of data like this:

A | B | C

1 Date Trailer Gallons
2 Wed 02/29/07
3 66 1599
4 148 9000
5 Thu 03/01/07
6 66 8008
7 Fri 03/02/07
8 148 21398

In my new book, I am using SUMPRODUCT on a static range "B4:B100." What I
need is for the Feb sheet to only SUMPRODUCT the data under 02/29/07 and the
Mar sheet to grab its own numbers off the same sheet.

So far, I've only managed to accomplish this by adding a formula to the
archived sheet that adds zeros to the array if the months don' t match. But
how can I accomplish the same thing with only a formula on the new sheet.

I appreciate any help.

Arlen