Excel-Subtotal Querry

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