Data consolidation in excel

Excel for Finance 2137 views 4 replies

Download the Practice Excel File of main Article "Data Consolidation in Microsoft Excel"

Regards,

KumarMukesh


Attached File : 304961 1396064 data consolidation.xls downloaded: 794 times
Replies (4)

Thanks Mukesh .I tried this ,but if i want to add foreign plant details into consolidated file,then what will be the formula ? 

=SUM(Eastern :foreign plant!C4),I tried this but it doesn't work

Dear Mansha, There is no need to change original formula you need to just ensure that foreign plant is situated in between Easrtern to Northern sheets. For more understanding kindly go though with my article on this function.

Dear Sir,

Very nice :)

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
22 May 2026
Sr. Financial Analyst - Consolidation

Search Synergy

Mumbai

CA

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
26 May 2026
Audit executive

vdsr & co LLP

Chennai

CA Inter

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details