E
Emeryville John
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
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