the sum of 2 columns thru a link

  • Thread starter Thread starter jv
  • Start date Start date
J

jv

Good day to all,

I have this profit & loss analysis wherein i have to get
the sum of 2 columns or multiple columns from one file and
display the result to another file.

1- maxim.xls 2 - analysis.xls

column: A B column: A
Cash Credit Expenses
12,613 14,500 27,113
5,608 19,486 25,094

Can anyone give a helping hand?

Thanks in advance.


jv
 
jv said:
Good day to all,

I have this profit & loss analysis wherein i have to get
the sum of 2 columns or multiple columns from one file and
display the result to another file.

1- maxim.xls 2 - analysis.xls

column: A B column: A
Cash Credit Expenses
12,613 14,500 27,113
5,608 19,486 25,094
Click to expand...

The easiest and safest way of putting in the formula is to open both
workbooks together. Then start putting in the formula:
=SUM(
and at this point navigate to the other workbook and select the range across
2 (or multiple) columns, just as you would if you were doing this in the
same workbook. Then type the closing bracket of the formula and press ENTER
to complete the entry.
Whilst the second workbook is open, the formula will look something like:
=SUM([maxim]Sheet1!A1:B1)
but when it is closed, it will include the drive and path, such as:
=SUM(c:\folder\[maxim.xls]Sheet1!A1:B1)
 
Back
Top