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!

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!

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!

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!

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 -