sumifs to other workbooks

C

Cresta

Hello
Is it possible to use the sumifs function to ranges on another workbook?

This is an example of how I'm referencing a named range ("Profitx") on the
other workbook;
'V:\Company Name Limited\Accounts09\Budgets\Rolling budget.xlsm'!Profitx

Is this correct?

Thanks
 
B

Bob Phillips

=SUMIFS('V:\Company Name Limited\Accounts09\Budgets\[Rolling
budget.xlsm]'!Profitx, ...
 
Top