banner_ad

Excel Subtotal querry?

This query is : Resolved 
Profile Image

Profile Image

(Querist)
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.
Profile Image

Rasesh

Profile Image

Rasesh (Expert)
25 March 2010 the best solution would be use of pivot table.
Profile Image

satya

Profile Image

satya (Querist)
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.
Profile Image

Rupesh

Profile Image

Rupesh (Expert)
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
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
Featured 26 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details