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
|