help with subtotal

[Sean15]

I created the file below using subtotal from Excel 2003. To format file, I clicked on no 2 in the top left hand corner of the work area. Excel seems to displays only column A (staff No) and column C (Amt). How can I display what's in column 2 (Name).

Staff No Name Amt
53 Total 7,399.35
34 Total 5,851.20
408 Total 5,468.00
32 Total 1,799.20
343 Total 4,716.40
45 Total 2,917.20
80 Total 2,212.00
59 Total 2,200.00
61 Total 2,706.00
82 Total 946.00
79 Total 4,680.00
90 Total 1,970.40
66 Total 4,782.80
47 Total 2,953.02
46 Total 6,571.20
88 Total 3,894.80
97 Total 6,760.00
77 Total 2,865.20
Grand Total 70,692.77

Thank you.

 

[Sean15]

It looks like I just got buried. Could you help me with this. Thank you.

Sean

 

[Sean15]

Could someone provide a solution to this question please.


Sean

 

[rallcorn]

Click the "3" in upper left corner to "expand"

 

[Sean15]

Thank you rallcorn. Clicking "3" shows all duplicate data which is not necessary. No. "2" format shows sub totals but Excel displays only column A (staff No) and column C (Amt). Is it possible to display columns A, B, C without showing all data?

I tried using SUMIF($A$2:$A$29,A2,$C$2:$C$29), but duplicate totals shows up.

Staff No Name Amt
53 a 3,745.35 7399.35
53 a 3,654.00 7399.35
34 b 2,925.60 5851.2
34 b 2,925.60 5851.2
408 c 2,734.00 5468
408 c 2,734.00 5468
32 d 1,799.20 1799.2
343 g 1,799.20 4716.4
343 g 2,917.20 4716.4

Could someone help.

Sean

 

[prabby25101981]

Why not use Pivot Tables? It will summarize the data in whichever way you want...

 

[rallcorn]

A pivot table would be my first choice, too. ALWAYS!!

 

[Sean15]

Pivot table works elegantly. Thank you.

Sean