Excel Subtotal querry?

This query is : Resolved

satya (Querist)
Follow

25 March 2010 Can any Excel Expert clarify my doubt;
My data having 1585 rows and A to K columns , I want to sum I,J,K columns, I already sorted my data, column “A” having Month and column “B” having Service name, Now I want subtotals as 1) Month wise 2) Service wise. When I subtotaling my data it is only either Month or Service wise option is appearing in subtotal function.

Please give best solution to solve my problem.

Rasesh

Rasesh (Expert)
Follow

25 March 2010 the best solution would be use of pivot table.

satya

satya (Querist)
Follow

26 March 2010 Dear Rasesh,
First I tried Pivot table, I will not able to satisfy what my data requires.
Please give me solution to satisfy with my 2 conditions.
Please , Please.

Rupesh

Rupesh (Expert)
Follow

30 March 2010 As already said, pivot table is the best solution. Or if you can send me your data and requirement, I would like to give a try.

rups2004@gmail.com