Summing from different workbooks

[srizki]

I have been asked this from one of my co-workers.
He wants a formula to add cells from different worksheets (same format, same cell), in different workbooks. i.e. say cell A25 of each worksheet needs to be add up.

Thanks in advance.

 

[Robert Mika]

Try this advice:

http://en.allexperts.com/q/Excel-1059/Sum-cell-across-multiple-1.htm

 

[srizki]

Thanks
but there is another one, consolidated in Mr. Excel that does better job I think, because with your formula, all workbooks need to be open.