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

If your table is in A1:C6, D1 contains your date criteria and E1 contains
your zip code criteria, try:

=Sumproduct(--(A2:A6=D1), --(B2:B6=E1), C2:C6)

If you are using XL2007, check help for the new SumIfs function.


"Emeryville John" wrote:

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