using your example, after subtotals have been set up, try this:

D1: name
E1: amount

G1: name
G2: *Total

Select your data range
DataFilterAdvanced Filter
Check: Copy to another location
List Range: (already selected)
Criteria Range: G1:G2
Copy to: D1:E1
Click the [OK] button

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"via135" wrote:


COL"A" COL"B"
name amount
a 10
a 20
a 10
b 40
b 20
c 10
c 10
c 30
d 20
d 30

when you use data|subtotals..for change in "name".. use function "sum"
u'll get the results as under:

a 40
b 60
c 50
d 50

r u able to understand..?

now i want to copy the list of

a 40
b 60
c 50
d 50

to another location for sum other calculation purpose.!

can u give me the solution?

-via135





keithl816 Wrote:
Try clarifying your question, what do you mean by your question?


how can i get a list of subtotals?


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=499188