I have the following data in a google spread sheet.
ColumnA ColumnB ======================= Bus 205 Train 10 Train 10 Fruit 10
I want to sum all ColumnB where ColumnA is equal to either Bus or Train.
I know that I can sum all content of B based on single value of A like below
=(SUMIF(A:A, "Bus", B:B))
But I want to sum if column A contains any of the values that I specify. How can I do that?