Data consolidation in excel

2182 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: 806 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 :)

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
Featured 16 July 2026
Semi Qualified Company Secretary

Vakilsearch.com

Chennai

CS

View Details
Company
23 July 2026
CA Inter

Vikram Jadhav and Company

Pune

CA Inter

View Details
Company
23 July 2026
Senior Accountant

Felicity Adobe LLP

Bengaluru

CA Inter

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
ARTICLESHIP 15 July 2026
CA Articles

Kinjal H Shah & Co.

Mumbai

CA Foundation

View Details
Company
21 July 2026
Chartered Accountant

Keshri & Associates

Thiruvananthapuram

CA

View Details
Company
16 July 2026
CA Inter, CA Intermediate, CA IPCC, CA CPT , CA SemiQualifie

Vakilsearch.com

Chennai

CA Inter

View Details