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
<tbody>
</tbody>
If someone could help it would be a really big help to me.
Thank you
Hailey
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
A | B | C | D | |
1 | location | Type | Customer | Revenue |
2 | MELBOURNE | CAR | RETAIL | $100 |
3 | MELBOURNE | BUS | RETAIL | $100 |
4 | SYDNEY | BUS | RETAIL | $200 |
5 | MELBOURNE | CAR | RETAIL | $200 |
6 | SYDNEY | BUS | CORPORATE | $150 |
7 | MELBOURNE | BUS | CORPORATE | $200 |
8 | SYDNEY | BUS | CORPORATE | $250 |
<tbody>
</tbody>
If someone could help it would be a really big help to me.
Thank you
Hailey