Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL with a condition
I have a Quantity column and a Unit Of Measure (UOM) column. I just want the
the SUBTOTAL of the Quantity for a particular UOM but not all of them. Is there a way to do this? Thanks for the help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL with a condition
use the Sumif function as shown below . Please note UOM has to be on
right of the qty to be summed uom qty pcs 2 litres 3 pcs 4 litres 5 =SUMIF(D20:E23,"pcs",E20:E23) HTH Regards Anirudh On Jan 11, 4:31*am, Prasad Basani wrote: I have a Quantity column and a Unit Of Measure (UOM) column. I just want the the SUBTOTAL of the Quantity for a particular UOM but not all of them. Is there a way to do this? Thanks for the help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL with a condition
If the user Auto Filters the data, is it going to update the sum to the
filtered rows? Thanks for the reply! "Ag" wrote: use the Sumif function as shown below . Please note UOM has to be on right of the qty to be summed uom qty pcs 2 litres 3 pcs 4 litres 5 =SUMIF(D20:E23,"pcs",E20:E23) HTH Regards Anirudh On Jan 11, 4:31 am, Prasad Basani wrote: I have a Quantity column and a Unit Of Measure (UOM) column. I just want the the SUBTOTAL of the Quantity for a particular UOM but not all of them. Is there a way to do this? Thanks for the help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL with a condition
When the user filters the data, the formula should be able to calculate the
SUM only for the filtered rows for that particular UOM. Is it not possible to do in Excel? Thanks "Prasad Basani" wrote: If the user Auto Filters the data, is it going to update the sum to the filtered rows? Thanks for the reply! "Ag" wrote: use the Sumif function as shown below . Please note UOM has to be on right of the qty to be summed uom qty pcs 2 litres 3 pcs 4 litres 5 =SUMIF(D20:E23,"pcs",E20:E23) HTH Regards Anirudh On Jan 11, 4:31 am, Prasad Basani wrote: I have a Quantity column and a Unit Of Measure (UOM) column. I just want the the SUBTOTAL of the Quantity for a particular UOM but not all of them. Is there a way to do this? Thanks for the help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL with a condition
In that case you can use a data subtotal option or a pivot table
based option Option 1 Data Subtotal - if list is sorted on UOM then using the Data subtotal option you can add qty for every change in UOM. Option 2 Create a pivot table based on your data with with UOM as row labels and qty as values HTH Regards Anirudh On Jan 11, 9:19*pm, Prasad Basani wrote: When the user filters the data, the formula should be able to calculate the SUM only for the filtered rows for that particular UOM. Is it not possible to do in Excel? Thanks "Prasad Basani" wrote: If the user Auto Filters the data, is it going to update the sum to the filtered rows? Thanks for the reply! "Ag" wrote: use the Sumif function as shown below . Please note UOM has to be on right of the qty to be summed uom * qty pcs * 2 litres * * * *3 pcs * 4 litres * * * *5 * * * =SUMIF(D20:E23,"pcs",E20:E23) HTH Regards Anirudh On Jan 11, 4:31 am, Prasad Basani wrote: I have a Quantity column and a Unit Of Measure (UOM) column. I just want the the SUBTOTAL of the Quantity for a particular UOM but not all of them. Is there a way to do this? Thanks for the help!- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
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 |