easy drag down formula for cells from different workbook

earned.xlsx monthly.xlsx

i want to get the earned workbook value to the monthly workbook result only from one cell... and to easily drag down the formula...plz help me out

Sorry but I don't totally understand what you mean.

Can you please post an example spreadsheet of the problem?

Thanks

Danny

Do you mean sum all the values in cell A2 on sheets jan'12,feb'12,mar'12, on a separate Sheet, if so will this do the trick!

=SUM('jan''12:march''12'!$A2)