Google Sheets - How can i Sum overlapping cells from several different imported named ranges?

Question

Im facing a bottleneck guys, hopefully someone can help me out to solve this.

Im working in Google Shets and have several named ranges i want to import in a single sheet, from several different files. So, what im using to import a single range is =importrange("sheeturl","namedrange")

What im struggling with is importing the other ranges like this and have all overlapping cells sum. See a simplified example of what im looking for in the image, below:

(https://i.sstatic.net/xhcfO.png)

i tried formulas like =sum(importrange("sheeturl1","namedrange1"),importrange("sheeturl2","namedrange2")) but this only summed all the values in a signle cell.

rockinfreakshow · Accepted Answer · 2023-11-21 19:37:44Z

0

You may try:

=arrayformula(
              importrange("Sheet_ID","NamedRange1")+
              importrange("Sheet_ID","NamedRange2")
              )

answered Nov 21, 2023 at 19:37

rockinfreakshow

30.7k4 gold badges19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Google Sheets - How can i Sum overlapping cells from several different imported named ranges?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related