Lisa/Toppers--Maybe I am missing something--but this is a routine task
in Excel. Instead of using formulas as Toppers recommends, which will
give Lisa the correct answer, but is harder for Lisa to learn and
apply to the next situation, I would:

Highlight the range with the Titles and Data/Sort by Group in
Ascending order..
Then I would highlight the sorted range--Data/Subtotal by Group. In
the Subtotal dialog box I would check the box "Group" "at each change
in" and check the box "sum" under the "Use function" and check the
box quantity under the words "Add Subtotal to."

This is what you get.

Group Qty
13 13.5
13 Total 13.5
14 135
14 407
14 946.29
14 Total 1488.29
25 18
25 Total 18
194 1.07
194 33.8
194 Total 34.87
200 192.7
200 107.4
200 202.5
200 613.7
200 613.7
200 Total 1730
370 39.99
370 Total 39.99
Grand Total 3324.65


Toppers--no disrespect intended--it is obvious to all that you are
extremely knowledgeable about Excel.

Steve G