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!