Multiple Sumifs
 

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

Multiple Sumifs
 

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