Can anyone help me figure out a formla that has a similar index match function,
but instead of picking the first selection of a repetitive item in the list,
itwouldsum the repetitive item in the total calculation. Please note
I'm not looking for a sumif formula, see example below.

Fig 1) source data
name units net rev
bear 1 1
10.00
bear 2 1
15.00
bear 1 2
20.00

Fig 2)
Report:
bear
1 bear 2
Unit
3 1
net rev 30.00 15.00

Fig 2 is the template that Ineedcreate a formula using one lookup
function that wouldmatchheadersacross the columns and
rowsdown the list.

Actually my data source is very large and it takes several sumifs and several
look up to pull in the report. Is there a one formula solution that can
accomodate all this pull?

I'll appreciate the help.