Hi Folks,

I wanted to have write a formula to sum up the item with specific unit and the expected set out is like that:

ITEM 1 10 PKT
ITEM 2 11 KG
ITEM 3 3 CTR
ITEM 4 5 KG
ITEM 5 30 KG
ITEM 6 5 PKT

Total PKT 15
Total KG 46
Total CTR 3

I tried with this formula:
=SUMPRODUCT(--(0&SUBSTITUTE(B3:B25, " PKT", "")))
but it shows ‘#value!”

Thank you

Ref.