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!
|