Forum Discussion

_jack30's avatar
_jack30
Copper Contributor
Dec 17, 2018

Help please

Example-

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

How do I add just taxi journeys together and just trains etc?
  • Fredrik123's avatar
    Fredrik123
    Copper Contributor

    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

Resources