Excel formula

[vino10]

Hi Guys,

I have 2 different report in 2 different excel file and its being updated daily, now i have to create another excel summary report consist of those 2 excel report which i need to have a formula. Is it possible to have another excel file w/ formula coming from 2 different excel.
EX.

=Sum(Excel1.sheet1+Excel2.sheet1)
is this possible? how?

Thanks in advance

 

[byundt]

Try either of the following syntaxes:
=SUM('[Book1.xls]Sheet 2'!$A$2 + '[Book2.xls]Sheet 3'!$B$40)
=SUM('[Book1.xls]Sheet 2'!$A$2:$A$5) + SUM('[Book2.xls]Sheet 3'!$B$40:B85)
The workbook name goes inside square brackets. The workbook name and worksheet are enclosed in single quotes if either of them contains a space.

You can add single cells from different workbooks within a single SUM, but if you are adding different ranges, then you need a SUM function for each range.

 

[vino10]

Thanks! byundt
I think i save time by this. thanks again