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

Reply Follow

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

Previous Thread

Next Thread

Related Threads

Start a New Discussion

Popular Discussion

Data consolidation in excel

4 Replies

Leave a reply

Recent Topics

Related Threads

Popular Discussion

Browse by Category

Subscribe to the latest topics :

Search Forum:

Get latest updates

Download CCI APP

Our Network Sites