Help please

Copper Contributor
Example-

Train | £70
Taxi | £13
Flight | £150
Taxi | £7

How do I add just taxi journeys together and just trains etc?
2 Replies
sumif formula is just for you.

Hi, as the person before me said. Sumif helps you.

 

See picture on how to use

 

It's like the IF condition and Search. If it finds Taxi in B2:B5 then it will sum those rows in C2:C5