Vlookup and Sum from Multiple Rows

[topmarx]

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:

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

 

[topmarx]

I think I figured it out:

I create a seprate column "total" and summed all months.

Then used:

=SUMIF(RANGE, B7, RANGE)