Hello
I have mutlipe business lines each with many products listed with revenue show next to them.
I want to vlookup from another cell/different tab all business lines and then capture and seum all monthly revenue into a single sell.
Identify all the matchting rows:
<tbody>
</tbody>
Then sum all corresponding values across multiple columns:
Total Revenue
Product 1
Product 2
Product 3
Busines 1
etc
Any help greatly appreciated
Thanks
I have mutlipe business lines each with many products listed with revenue show next to them.
I want to vlookup from another cell/different tab all business lines and then capture and seum all monthly revenue into a single sell.
Identify all the matchting rows:
Business 2 | Product 3 | 45325 | 3 | 345 | 33 |
Business 1 | Product 1 | 6544 | 43 | 463 | 15463 |
Business 3 | Product 2 | 645 | 456 | 43 | 5463 |
Business 1 | Product 3 | 6456 | 3634 | 456 | 4563 |
Business 2 | Product 1 | 64 | 456 | 456 | 87 |
Business 3 | Product 1 | 46 | 456 | 654 | 456 |
<tbody>
</tbody>
Then sum all corresponding values across multiple columns:
Total Revenue
Product 1
Product 2
Product 3
Busines 1
etc
Any help greatly appreciated
Thanks