Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotals
I would like to create a macro (or vba function) that subtotals by user
then by type. I have two fields that I would like to total, amount and reimbursement amount. I would like the macro to sort and subtotal on type and then provide a grand total by user. I have three different types (P, C & R). I tried using the sort and subtotal functions in excel (2003) but have not had any success. Can someone please point me in the right direction? kind regards, |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotals
Since you provide little info, If I understand you don't need to subtotal.
Try this idea =sumproduct((a2:a22="P")*(b2:b22="username")*c2:c2 2) -- Don Guillett Microsoft MVP Excel SalesAid Software "DumbCluck" wrote in message ... I would like to create a macro (or vba function) that subtotals by user then by type. I have two fields that I would like to total, amount and reimbursement amount. I would like the macro to sort and subtotal on type and then provide a grand total by user. I have three different types (P, C & R). I tried using the sort and subtotal functions in excel (2003) but have not had any success. Can someone please point me in the right direction? kind regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) |