The problem of linking books to each other

Copper Contributor

A problem arose in linking books to a formula. When the linked book is closed, the “VALUE!” Error appears when starting the linked book. data is updated and tightened What could be the problem? Formula apply in this situation COUNTIFS

6 Replies
The COUNTIFS function only works with an external reference if the referenced file is also open in Excel.
Can you tell me then what function I can replace COUNTIFS so as not to constantly open the second book? maybe SUMIFS?
You could pull in the data using the Get Data button on the Data tab and then create a pivottable rather than using the COUNTIFS or SUMIFS functions.
I will not be able to transfer all the data through the pivot table, since the search is about the coincidence of names from a chaotic list, the lists are spread over several columns. Or did I misunderstand your thought?
Alternatively, retrieve the data into a separate worksheet of your current file (using the Get Data technique) and then do the SUMIFS or COUNTIFS against that worksheet.
thanks for the recommendation, I will try