带单位数字如何计算？

单行计算
=PRODUCT(SUBSTITUTE(SUBSTITUTE(A2:B2," 元/斤",""),"斤",)*1)

多行计算
=SUMPRODUCT(IF({1},SUBSTITUTE(SUBSTITUTE($A$2:$A$3," 元/斤",""),"斤",)*1)*IF({1},SUBSTITUTE(SUBSTITUTE($B$2:$B$3," 元/斤",""),"斤",)*1))

let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
更改的类型 = Table.TransformColumnTypes(源,{{"单价", type text}, {"数量", type text}}),
已添加自定义 = Table.AddColumn(更改的类型, "取单价", each Number.From( Text.Remove([单价],{"一".."龟","/"}))),
已添加自定义1 = Table.AddColumn(已添加自定义, "取数量", each Number.From(Text.Remove([数量],"斤"))),
已添加自定义2 = Table.AddColumn(已添加自定义1, "金额", each [取数量]*[取单价]),
删除的列1 = Table.RemoveColumns(已添加自定义2,{"取单价", "取数量"})
in
删除的列1