Home / Questions / 245602
Accepted
Iván Montero
Asked: 2020-03-15 01:40:41 +0800 CST 2020-03-15 01:40:41 +0800 CST

Select the maximum value of a range of cells from another sheet in google sheet

  • 772

I am trying to select the maximum value of a range of cells from another sheet in google sheets, but I cannot find the formula, I have tried different formulas:

=IMPORTRANGE("Enlace";"Resums per parc!max(D17:F17)")

=query(IMPORTRANGE("Enlace") "Select max(D,E,F) where B=TOTAL")

=query(IMPORTRANGE("Enlace") "Select max(Col4,Col5,Col6) where Col2=TOTAL")
google-hoja-de-cálculo

1 Answers

  1. Best Answer

    Would:

    =MAX(IMPORTRANGE("<URL>"; "Resums per parc!D17:F17"))

    MAX to get the maximum. And you pass the interval, which will be the result of IMPORTRANGE.

    IMPORTRANGE to import from another document. You pass it the URL of the sheet ( "<URL>"), and then the range you want to import ( 'Resums per parc'!D17:F17).

    • 1