How to reduce the number of importrange?

Question

Google Sheets

Good time!

I need help, please tell me how to correctly implement calculations in order to minimize the use of heavy functions, in particular IMPORTRANGE

An example of what it is about https ://docs.google.com/spreadsheets/d/1w45k1YqrHH...

Sheet2" in cell A2, I determine the number of unique records by importing data (since the data is in another table in reality, but here, just for example, I transferred it to the same table).
Then in column B I summarize the values ​​for each entry by importing the data.
I suspect that this can be shortened and not duplicated with import formulas, but I don’t understand how to do this. And I would not want to create intermediate sheets either. Please help!

Answer 1

Just import the maximum possible range, preferably the whole sheet, and work with it.