This would be MUCH simpler if you kept numbers and text separate. I would put TYPE in it's own column, Amount in it's column and Unit in it's own column - this will also make entering data easier too.
This way, your formula works fine...
A B C D E F G H 1date iteam amount 2 1/9/2021mutton 5kg 2000 3 1/9/2021mutton 10kg 5000 4 1/10/2021mutton 3kg 1500mutton 19600 5 1/11/2021mutton 5kg 2000Chicken 4700 6 1/15/2021mutton 6kg 2100 7 1/16/2021mutton 15kg 7000 8 1/9/2021chicken 1kg 200 9 1/9/2021chicken 5kg 1000 10 1/9/2021chicken 3kg 600 11 1/10/2021chicken 3kg 600 12 1/11/2021chicken 10kg 2000 13 1/15/2021chicken 1kg 100 14 1/16/2021chicken 2kg 200
H4=SUMIFS(E:E,B:B,G4)
copied down
Bookmarks