Sumifs one of the column meet the criteria

[Eran2]

Hi all,
I have table with 120,000 trips.
Each trip have a column with origin city and a column with destination city.
I want so sum the the quantity column, for all trips that either the origin column=Manchester or the destination column=Manchester .

Example attached below. I want my formula to sum all the bold numbers.

origin	destination	quantity
London	Manchester	3,521
Bristol	London	2,100
Manchester	Bristol	402
Manchester	Manchester	900

Thanks a lot in advance!

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1	origin	destination	quantity
2	London	Manchester	3,521		Manchester	4823
3	Bristol	London	2,100
4	Manchester	Bristol	402
5	Manchester	Manchester	900
6
Main

Cell Formulas
Range	Formula
F2	F2	=SUM(FILTER(C2:C10,(A2:A10=E2)+(B2:B10=E2)))

 

[Eran2]

Super helpful. Thanks so much!

 

[Fluff]

You're welcome & thanks for the feedback.