How can we help you today?

Search for answers to your questions by entering keywords below, or look through our knowledge base.

Welcome to 'Sikkhon' User Forum

Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users. You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.

Formula to Calculate Sum of Cells in Separate Workbook

Un Answered

Today, We will learn how do I sum across multiple workbooks in Microsoft Excel.  I am talking about the workbook, not the worksheet. 

Suppose you have two workbooks, in the workbooks, you have value in same cell or different cell. 

Just use the sum formula like =SUM([Book112.xlsx]Sheet1!C3:C6)

We created a workbooks Book112.xlsx & Data listed in C3:C6

Give the address of first workbook and second workbook and get the answer.

0 Votes


Login or Sign up to post a comment