Excel-Subtotal Querry

 

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.

Replies (4)

MS-EXCEL FOR ALL

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

Thank u very much  Mr.Girish,

for your reply reg. my querry of Subtotal, if there is no other way (Automatically) , Manually copying each month, what you told in the mail is best.


My pleasure SatyaDharini

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details