M
M
mikushka2021-12-23 17:13:16
Google Sheets
mikushka, 2021-12-23 17:13:16

What can be the formula for the sum of ranges for different sheets?

We need a formula that would calculate the sum of a fixed range (let's say A2:A) in different sheets. Moreover, so that the formula takes the names of these sheets from the range (let's say B2:B16) in the "List" sheet. In other words, so that the formula calculates the sum in different sheets, and takes the names of these sheets from the "List" sheet.
If it were simple, it should be something like =sum('('Список'!B2:B16)'!A2:A), but it doesn't work that way.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-12-23
@ProgrammerForever

=arrayformula({
B2&"!A2:A";
B3&"!A2:A";
B4&"!A2:A"
})

etc.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question