Grouping table data into smaller table

Originally Posted by Pete_UK

Put this formula in F2:

=SUMIF($A:$A,$E2&"*",B:B)

and it should copy down automatically.

Copy into G2, and again it should fill the cells below.

Hope this helps.

Pete

Hi Pete, thanks for the help, it helped but only in a short term.
As this is in alphabetical order, in future, what if the subject on the first table and the subject in the second table aren't in alphabetical form?

For instance, I have a list of members with their names in Table 1

<Salesperson><Number of Packages Sold><$ Sales>
Peter-100-6200
Paul-150-4100
Mary-450-8000
Jess-600-2150
...(n>100)

<Sales Managers><Number of Packages Sold from their members><$ Sales>
John-550-14200
Jane-750-6250
...(n>20)
*where Peter and Mary is under John, where Paul and Jess is under Jane

Is there a coding/function that could facilitate this? Thanks!