Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to do a subtotal on below to give me the total amount by month per
supplier. e.g supplier ste01 for Jan09 will show 1604, and for feb09 it will show 137 and then onto the next supplier zed01 broke down by month again. Supplier Date Amount ste01 01/01/2009 1 ste01 06/01/2009 45 ste01 10/01/2009 1558 ste01 01/02/2009 15 ste01 17/02/2009 15 ste01 18/02/2009 48 ste01 19/02/2009 57 ste01 20/02/2009 2 zed01 01/01/2009 37 zed01 02/01/2009 41 zed01 06/01/2009 42 zed01 25/02/2009 4 zed01 26/02/2009 24 zed01 01/03/2009 2 zed01 02/03/2009 7 zed01 03/03/2009 75 zed01 04/03/2009 58 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please help - subtotal using vlookup depending on variable month | Excel Discussion (Misc queries) | |||
Supplier scorecard | Excel Discussion (Misc queries) | |||
Select Minimum value and return the name of the supplier | Excel Worksheet Functions | |||
subtotal nesting errors new this month | Excel Worksheet Functions | |||
Need cell formula to subtotal gross by month for a quarter | Excel Discussion (Misc queries) |