top of page
Search

Combine IMPORTRANGE with SUM or QUERY in Google Sheets

  • May 22
  • 1 min read

You can combine the IMPORTRANGE function with other functions to analyse data in other Google Sheets files. Here are a couple of examples.


IMPORTRANGE and SUM

Using IMPORTRANGE with the SUM function, you can show the sum of a range in another Sheets file.


To do this, start with the SUM function, then add the IMPORTRANGE formula. For the

In the range section of the formula, enter the range for which you want the sum.


For example, here I have used both these functions to show the total of sales in column F in another Sheets file.


Example of a SUM and IMPORTRANGE formula in Google Sheets for total sales

IMPORTRANGE and QUERY

To import and manipulate data from another Sheets file, use IMPORTRANGE & QUERY.


For example, here I have imported data from a feedback sheet, but only when ‘Client A’ is mentioned.


Example of a QUERY and IMPORTRANGE formula in Google Sheets

To learn more about Google Sheets, purchase one of our on-demand training courses:


bottom of page