SumIF(??) at Date and Item Change
 

If I have a spreadsheet sorted by Item# and by week date. There are 8
different dates for each item. Is there a formula that would give a total
for each different week for each Item#?

In the example below it would give a total of $25.00 for week 1/1/05 for
item# 888888. Total of $16 for week 1/8/05 for item# 888888. $15.00 Total
for week 1/1/05 for item# 999999 and $4.00 total for week 1/11/05 for item#
999998

Date Item# Amount
1/1/05 888888 $13.00
1/1/05 888888 $12.00
1/8/05 888888 $16.00
1/1/05 999999 $15.00
1/11/05 999999 $ 4.00

SumIF(??) at Date and Item Change
 

=SUMPRODUCT(--(A2:A20=--"2005-01-01"),--(B2:B20=888888),C2:C20)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Supe" wrote in message
...
If I have a spreadsheet sorted by Item# and by week date. There are 8
different dates for each item. Is there a formula that would give a total
for each different week for each Item#?

In the example below it would give a total of $25.00 for week 1/1/05 for
item# 888888. Total of $16 for week 1/8/05 for item# 888888. $15.00
Total
for week 1/1/05 for item# 999999 and $4.00 total for week 1/11/05 for
item#
999998

Date Item# Amount
1/1/05 888888 $13.00
1/1/05 888888 $12.00
1/8/05 888888 $16.00
1/1/05 999999 $15.00
1/11/05 999999 $ 4.00

SumIF(??) at Date and Item Change
 

You can do this with a formula or you might want to look at a pivot table.

If you want this as a formula where do you want it - in the column to the
right or in a summary area?

--
Cheers,
Shane Devenshire


"Supe" wrote:

If I have a spreadsheet sorted by Item# and by week date. There are 8
different dates for each item. Is there a formula that would give a total
for each different week for each Item#?

In the example below it would give a total of $25.00 for week 1/1/05 for
item# 888888. Total of $16 for week 1/8/05 for item# 888888. $15.00 Total
for week 1/1/05 for item# 999999 and $4.00 total for week 1/11/05 for item#
999998

Date Item# Amount
1/1/05 888888 $13.00
1/1/05 888888 $12.00
1/8/05 888888 $16.00
1/1/05 999999 $15.00
1/11/05 999999 $ 4.00

SumIF(??) at Date and Item Change
 

The person I'm doing this for doesn't want to use a pivot table. Just wants
to add a formula to the existing spreadsheet.

I was going to insert a few columns to the left of all the data. If it
needs to be to the right that is fine.


"ShaneDevenshire" wrote:

You can do this with a formula or you might want to look at a pivot table.

If you want this as a formula where do you want it - in the column to the
right or in a summary area?

--
Cheers,
Shane Devenshire


"Supe" wrote:

If I have a spreadsheet sorted by Item# and by week date. There are 8
different dates for each item. Is there a formula that would give a total
for each different week for each Item#?

In the example below it would give a total of $25.00 for week 1/1/05 for
item# 888888. Total of $16 for week 1/8/05 for item# 888888. $15.00 Total
for week 1/1/05 for item# 999999 and $4.00 total for week 1/11/05 for item#
999998

Date Item# Amount
1/1/05 888888 $13.00
1/1/05 888888 $12.00
1/8/05 888888 $16.00
1/1/05 999999 $15.00
1/11/05 999999 $ 4.00