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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Business 2[/TD]
[TD]Product 3[/TD]
[TD]45325[/TD]
[TD]3[/TD]
[TD]345[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]Business 1[/TD]
[TD]Product 1[/TD]
[TD]6544[/TD]
[TD]43[/TD]
[TD]463[/TD]
[TD]15463[/TD]
[/TR]
[TR]
[TD]Business 3[/TD]
[TD]Product 2[/TD]
[TD]645[/TD]
[TD]456[/TD]
[TD]43[/TD]
[TD]5463[/TD]
[/TR]
[TR]
[TD]Business 1[/TD]
[TD]Product 3[/TD]
[TD]6456[/TD]
[TD]3634[/TD]
[TD]456[/TD]
[TD]4563[/TD]
[/TR]
[TR]
[TD]Business 2[/TD]
[TD]Product 1[/TD]
[TD]64[/TD]
[TD]456[/TD]
[TD]456[/TD]
[TD]87[/TD]
[/TR]
[TR]
[TD]Business 3[/TD]
[TD]Product 1[/TD]
[TD]46[/TD]
[TD]456[/TD]
[TD]654[/TD]
[TD]456[/TD]
[/TR]
</tbody>[/TABLE]

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)