Home

Help please

Highlighted
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
Highlighted
sumif formula is just for you.
Highlighted

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