-1

I am attempting to sum quite a few different ranges of IMPORTDATA()

I want to do something like:

=SUM(N9:N14,N16:N21,N23:N36,N38:N53,N55:N106,N108:N113)

My issue is it can't sum up a bunch of different IMPORTDATA(). It is reading what is inside and not what is being shown.

Improve this question

1 Answer 1

Reset to default
0

For what I tried so far it doesn't. Doesn't work like excel in that aspect. Either you can paste the range using Importrange("url","sheet!A:A") which will populate the column with all A:A data from external sheet or copy and paste the data values and then work with it.

Improve this answer
1
  • Actually, you could (unless they are many) sum(importdata(1), importdata(2)...importdata(n)), that should work as each importdata returns a value and sum() can add those values
    – Manuel Ramirez
    Nov 8, 2019 at 16:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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