Excel-Subtotal Querry

satya (Executive Excise) (1839 Points)

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.