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