Home

Help please

_jack30
Occasional Visitor
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