• 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.

Sum cell from multiple workbooks formula

T

tpheath

New Member
There are 13 workbooks in a folder (that also contains other workbooks and files). I am creating a consolidated workbook and I need to sum the values on the DashboardStats sheet cell B38, from each workbook.


I would like to do this with a formula, not VB.


I tried =SUM(Client1.xlsx:Client13,xlsx!B38) but this does not work. If I put in the entire path for each file, the formula will be to long.
 
You must log in or register to reply here.
Back
Top