• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help reqd for Array Formula to Consolidate 12 sheets

R

rush2rajen

Member
Hi Excel Gurus,

Help required to use some Array formula or any shortcut which will help in consolidating 12 worksheet Deptwise in One Summary Sheet. File attached for reference.


Thanks
Raj
 

Attachments

Raj

Provided the sheets have data in the same structure with Rows holding the same data you can simply use:
In the DEPTWISE SALES 2013 - 2014 worksheet in cell F2:
=SUM(KHARDAH:SILIGURI!B2)
Copy across and down
 
You must log in or register to reply here.
Back
Top