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

ICICI

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"

Regards,

KumarMukesh



 4 Replies


(Guest)

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


(Guest)

=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

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