SUMIFS would do the job
= SUMIFS( data[Total], data[ITEM NAME], [@[ITEM NAME]], data[UOM], [@UOM] )
With dynamic arrays that becomes a single formula
= SUMIFS(data[Total], data[ITEM NAME], ITEM_NAME, data[UOM], UOM )
where the ranges ITEM_NAME and UOM are created by the formula
= UNIQUE( data[[ITEM NAME]:[UOM]] )