You want to treat the drugid and client# as one field (essentially)?

How about using a helper column:

=a2&"!"&b2
and drag down.

Then subtotal using that column.

Then you could hide the details
select the range to copy
edit|goto|special|check visible
copy and paste.

Then insert another column to the right of that combined field.
select that column and do data|text to columns|delimited by the !.

You may want to learn a bit about data|Pivottable. It may do what you want a
little easier (after investing a little learning time).





Steve D wrote:

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)

--

Dave Peterson