SUBTOTAL with a condition

  • Thread starter Thread starter Prasad Basani
  • Start date Start date
P

Prasad Basani

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!
 
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
 
If the user Auto Filters the data, is it going to update the sum to the
filtered rows?

Thanks for the reply!
 
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
 
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
 
Back
Top