Help Please -Sum off multiple adjacent cells

[hailey123]

Hi,

I require some help please. I am looking for an equation to that will sum based on multiple adjacent cells have specific terms.

I need to total the revenue in row D for all lines that have a specific working in Row A B and C

See example below:

I need a formula to automatically calculate the total revenue in Column D doe:

Melbourne + Car + Retail
Melbourne + Bus + Retail

etc etc

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]location[/TD]
[TD]Type[/TD]
[TD]Customer[/TD]
[TD]Revenue[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]MELBOURNE[/TD]
[TD]CAR[/TD]
[TD]RETAIL[/TD]
[TD]$100[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]MELBOURNE[/TD]
[TD]BUS[/TD]
[TD]RETAIL[/TD]
[TD]$100[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]SYDNEY[/TD]
[TD]BUS[/TD]
[TD]RETAIL[/TD]
[TD]$200[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]MELBOURNE[/TD]
[TD]CAR[/TD]
[TD]RETAIL[/TD]
[TD]$200[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]SYDNEY[/TD]
[TD]BUS[/TD]
[TD]CORPORATE[/TD]
[TD]$150[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]MELBOURNE[/TD]
[TD]BUS[/TD]
[TD]CORPORATE[/TD]
[TD]$200[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]SYDNEY[/TD]
[TD]BUS[/TD]
[TD]CORPORATE[/TD]
[TD]$250[/TD]
[/TR]
</tbody>[/TABLE]

If someone could help it would be a really big help to me.

Thank you
Hailey

 

[sheetspread]

Sumifs is a formula solution. Or you can set a pivot table.

 

[hailey123]

Sumifs is a formula solution. Or you can set a pivot table.

Are you able to assist me with a formula?, I tried and somehow I'm mucking it up. Thankyou

 

[hailey123]

I figured it out - thankyou!