Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal
Here's my scenario. I have several status codes besides the example below.
I want to put a counter on a spreadsheet that adds the qty for each code. so for MT the sum of items in that code is 5. what is the formula? Qty Status 2 MT 1 MT 1 MT 2 MT |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal
You can put your unique list of codes in D1 and below, for example,
then in E1 you can use this formula: =SUMIF(B:B,D1,A:A) and then copy this down as required. Hope this helps. Pete On Apr 8, 7:12*pm, Gallego wrote: Here's my scenario. *I have several status codes besides the example below. * I want to put a counter on a spreadsheet that adds the qty for each code. *so for MT the sum of items in that code is 5. *what is the formula? Qty * * Status 2 * * * MT 1 * * * MT 1 * * * MT 2 * * * MT |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal
Take a look at this:
http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot07.html#Unique Regards, Ryan-- -- RyGuy "Pete_UK" wrote: You can put your unique list of codes in D1 and below, for example, then in E1 you can use this formula: =SUMIF(B:B,D1,A:A) and then copy this down as required. Hope this helps. Pete On Apr 8, 7:12 pm, Gallego wrote: Here's my scenario. I have several status codes besides the example below. I want to put a counter on a spreadsheet that adds the qty for each code. so for MT the sum of items in that code is 5. what is the formula? Qty Status 2 MT 1 MT 1 MT 2 MT |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal
The OP emailed his sheet directly to me last night (without
asking !!), so I put the formula in there and sent it back to him. Pete On Apr 9, 3:48*pm, ryguy7272 wrote: Take a look at this:http://peltiertech.com/Excel/Pivots/...07.html#Unique Regards, Ryan-- -- RyGuy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |