Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

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.

Reply
Follow
Share

4 Replies

(Guest)

MS-EXCEL FOR ALL

Upgrade to CAclubindia Pro. Subscribe Now!

CA GIRISH (Chartered Accountant) (1796 Points)
Replied 26 March 2010

USE THE AUTO FILTER OPTION

SELECT THE ROW WHICH HAS HEADINGS THEN

DATA-FILTER-AUTO FILTER

THEN CLICK ON THE ARROW ON MONTH COLUMN SELECT THE MONTH U WANT TO.(OR USE CUSTOM OPTION WHERE U CAN SELECT MULTIPLE MONTHS) , YOU WILL GET THE DATA FOR THAT RESPECTIVE MONTH THEN SELCT THE ARROW MARK ON SERVICE COLUMN , SELECT THE SERVICE U WANT TO AND U R DONE . GET THE TOTAL FOR THE MONTH AND SERVICE .BUT YOU HAVE TO SELECT MONTH FIRST IF YOU WANT TO SEE A INCOME FROM PARTICULAR SERVICE IN A PARTICULAR MONTH .

IF YOU R STILL NOT CLEAR.MAIL ME THE FILE( REMOVE CLIENTS NAME FOR SECRECY )I WILL RESEND IT TO U WITH SUBTOTALS WITH HOW TO IN PICTORIAL FORMAT.HERE girishism.theoryg @ gmail.com