Howdy,

Here is what my data looks like:

Date Zip Code Widgets
1/1/08 10001 1
1/1/08 10002 2
1/1/08 10001 3
1/3/08 10001 4
1/5/08 10004 5

I want to sum the # of widgets when the zip code and date are the same. So
my output would be:

1001

Date Widgets
1/1/08 4
1/2/08 0
1/3/08 4
1/4/08 0
1/5/08 0

So I am going to create a table with the dates running down the column and
then I want to put a formula in the widgets column that will search the
original data, the new date column and the number 10001.

Thanks for your help.

John