Avail 20% discount on updated CA lectures for Dec 21 .Use Code RESULT20 !! Call : 088803-20003


Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer)     11 January 2015

Data consolidation in excel

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



 4 Replies


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

CA Kumar Mukesh

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer)     21 January 2015

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.

Shraddha (Chartered Accountant)     31 January 2015

Dear Sir,

Very nice :)


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Start a New Discussion

Popular Discussion

view more »

Subscribe to the latest topics :
Search Forum:

Trending Tags