Hello hitzexcel,

Welcome to the Forum!

You can use this formula to sum the values for "Gas". The formula was written using column "A" and "B" where "A" is the amount and "B" is the item.
=SUMIF(B2:B13,"=Gas",A2:A13)