sumifs to other workbooks

  • Thread starter Thread starter Cresta
  • Start date Start date
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
 
=SUMIFS('V:\Company Name Limited\Accounts09\Budgets\[Rolling
budget.xlsm]'!Profitx, ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

custom function closed workbooks 3
Save As and new workbook new name used in existing code 8
VBA : Sumif on different workbooks! ********* 1
Run macro from active workbook whose name keeps changing 20
Indirect and sumif functions with multiple workbooks 1
sumif wildcard for text and numbers 2
sumifs question 2
Delimma: SumIf worksheet function 0

Back
Top