How to get sum of data in series from 2 Workbooks to another Workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

adeel - 26 Mar 2007 06:06 GMT

I have 2 workbooks with series of numeric data (i.e A1 to A100 in both
workbooks), I want to generate automatic Sum of these data in another
workbook (Cell by Cell), which linked to Workbook-1 & 2. pls tell me the
formula for that.

I shall be highly gratful to you.

Reply to this Message

FloMM2 - 22 Apr 2007 11:54 GMT

adeel,
If I understand the question, Workbook3 in cell [A1] will be the sum of
Workbook1 cell [A1] plus Workbook2 cell [A1].
In the Workbook that the total is wanted in the cell:
=SUM([Book1]Sheet1!R1C1,[Book2]Sheet1!R1C1)
In english( not excel-ish)
add from Workbook1 the appropriate sheet, cell [A1] to from Workbook2 the
appropriate, cell [A1] and store it in Workbook3 sheet1 in cell [A1].
HTH

:-)

> I have 2 workbooks with series of numeric data (i.e A1 to A100 in both
> workbooks), I want to generate automatic Sum of these data in another
> workbook (Cell by Cell), which linked to Workbook-1 & 2. pls tell me the
> formula for that.
>
> I shall be highly gratful to you.

Reply to this Message