0

I'm building a complex Google Sheets document and for one sheet I use the function IMPORTRANGE. It's very handy and imports new rows from another sheet when they are added. The problem is this:

After the last row of the import from my IMPORTRANGE I add a small 'Total' calculation to SUM all of the above numbers.

What I want is that the 'total' calculation row moves down when the IMPORTRANGE expands with more rows.

Is there any way to achieve this dynamically / automatically so that my 'Total' calculation moves down and keeps summing?

0

Use the Google Sheets array handling feature

Example

Lets assume that A1 has the spreadsheet key required by IMPORTRANGE, that eh source spreadsheet has only the rows required to hold the data (no blank rows) and that the formula is set in A2

={IMPORTRANGE(A1,"data!A:A"},SUM(INDIRECT("A2:A"&(ROW()-1))}

See the wiki for references and related questions.

  • If you have problems with the above formula create a couple of demo spreadsheets, one to to hold the data to imported and the other to import the data and add the link to the question. – Rubén Jan 8 at 15:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.