I have a large file that has all of the drugs that our patients have taken
for a period of time. I need to get a subtotal by the drug number (average
cost) and the number of clients that have received the drugs by drug number.

Is there a way to get both the subtotals on a single line. I need to
transfer the data from this worksheet to another sheet provided by
contractor.

The file looks similar to this.

NDC# (drug ID)
Client#
Unit Cost
Date
(asst' other columns)