Answer the question
In order to leave comments, you need to log in
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
=arrayformula({
B2&"!A2:A";
B3&"!A2:A";
B4&"!A2:A"
})
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question