Help please

Occasional Visitor

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