If cell contains a certain text, add the numbers of another cell [Closed]

Report
Posts
2
Registration date
Saturday February 4, 2017
Status
Member
Last seen
February 5, 2017
-
B2=Supermarket , C2=30$
B3=Fuel, C3=20$
B4=Fuel, C4=50$

if Bs="Fuel", i want to add the numbers in the adjacents cells together. but only if they contain the text in the B cells.
how can that be done without having to name each cell in case the list is long:
=IF(H6="Fuel", I6, 0)+IF(H7="Fuel", I7, 0)+IF(H8="Fuel", I8, 0)+IF(H9="Fuel", I9, 0)+IF(H10="Fuel", I10, 0)+IF(H11="Fuel", I11, 0) ...

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!