View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Supe Supe is offline
external usenet poster
 
Posts: 59
Default 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