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