Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use a macro to change the selected item in data validation | Excel Discussion (Misc queries) | |||
How do I change the order of item in a legend for a chart? | Charts and Charting in Excel | |||
SUMIF with Exception of multiple Item | Excel Discussion (Misc queries) | |||
sum item within certain date range | Excel Discussion (Misc queries) | |||
Max Date and Item - How to get in one sheet ? | Excel Worksheet Functions |