sumifs to other workbooks
 

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

sumifs to other workbooks
 

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

--
__________________________________
HTH

Bob

"Cresta" wrote in message
...
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