How to create a plus-sign-seperated-string of all columns between two given columns?

Question

I need to sum all of the columns between two given columns in a query.

So, I need to figure out how to create a plus-sign-seperated list of all columns letters, between two given columns letters.

The formula should take two inputs, the starting column (e.g. 'P'), and the ending column (e.g. 'AC'), and output a plus-sign-seperated string of column letters ('P+Q+R+S+T+U+V+W+X+Y+Z+AA+AB+AC')

Input 1: 'P'

Input 2: 'AC'

Expected output: 'P+Q+R+S+T+U+V+W+X+Y+Z+AA+AB+AC'

Example of complete expected query: '=QUERY(data, SELECT "P+Q+R+S+T+U+V+W+X+Y+Z+AA+AB+AC")'

I have tried to tweak a formula I found via a related post without any success.

WIP sheet: https://docs.google.com/spreadsheets/d/1ewNMdx2BXI8pVnZehX4kHrMVAvWNbbjeIW-hrXUIPeA/edit?usp=sharing

Related posts: google sheets, Make letters separated by comma given number of following columns. Not using app script, just formulas please

Any help would be much appreciated!

UPDATE

How to create a plus-sign-seperated list of column letters, between two given column letters?

Formula: =LAMBDA(letters,TEXTJOIN("+",1,FILTER(letters,SEQUENCE(COUNTA(letters))>=MATCH(B3,letters,0),SEQUENCE(COUNTA(letters))<=MATCH(B4,letters,0))))

Note

• In the above mentioned formula, B3 is input1 (i.e. the start column), and B4 is input2 (i.e. the end column).
• The sheet where you place the formula must include the columns you specify in input1 and input2.

Latest demo

https://docs.google.com/spreadsheets/d/1Kl29_0o8mKfeD--vkZHKU3EIf9hl-ts93gX8Ou08EwY/edit?usp=sharing

Answer 1

There are possibly other ways of doing what you expect without the concatenation of letters. Here you have a formula that does what you expect adapting our example:

=LAMBDA(letters,TEXTJOIN("+",1,FILTER(letters,SEQUENCE(COUNTA(letters))>=MATCH(A1,letters,0),SEQUENCE(COUNTA(letters))<=MATCH(B1,letters,0))))(ArrayFormula(REGEXREPLACE(ADDRESS(1,SEQUENCE(COLUMNS(1:1)),4),"\d+","")))

I was asking for your final expected result, because you could use other ways. For example if you need the sums per row:

=QUERY({Sheet2!A:D,BYROW(INDIRECT("Sheet2!"&A1&":"&B1),LAMBDA(e,SUM(e)))},"Select * Where Col1 is not null",1)

This would be a QUERY where you previously sum with indirect the columns you desire row by row and then apply the QUERY. Obviously you'd be able to add all the conditions you need too!

UPDATE

Here you have a way of doing it with dates:

=QUERY({Sheet1!A:C,BYROW(FILTER(Indirect("Sheet1!H1:"&ROWS(Sheet1!H:H)),Sheet1!H1:1>=MAX(0,B5),Sheet1!H1:1<=MIN(B6,999^99)),LAMBDA(r,SUM(r)))},"Select *"&IF(B7="",""," where Col1 = '"&B7&"'")&"label Col4 'Hours'", 1)

• Indirect("Sheet1!H1:"&ROWS(Sheet1!H:H)) allows you to go from the H1 to the last column. It's like H1:1000, or H1:2345 depending on your current amount of rows in Sheet1
• With FILTER I see when the dates are greater or smaller than the two variables. I added the MIN and MAX values so you can leave the values empty in case you don't want to establish one of those values
• With BYROW I find the sums of that filtered range of dates "row by row"
• All inside QUERY leaves a four column range, being the fourth the amount of hours of each row with the filtered dates. I've added the option to filter or not by the name in B7 (you can leave it empty if you want)

Let me know! It's in Copy of Sheet2

Answer 2

This Google Apps Script asks you for Input 1 and Input 2 and returns all column letters between.

Input 1 = C

Input 2 = J

Output = C+D+E+F+G+H+I+J

You need to specify the cell to set the value with this output.

function getColumnLetters() {
        var sheet = SpreadsheetApp.getActiveSheet();
        var startColLetter = Browser.inputBox("Letter of the starting column:");
        var endColLetter = Browser.inputBox("Letter of the ending column:");

        var startColIndex = sheet.getRange(startColLetter + "1")
                                 .getColumn();
        var endColIndex = sheet.getRange(endColLetter + "1")
                               .getColumn();

        var columnCount = endColIndex - startColIndex + 1;
        var columnLetters = [];
        for (var i = 0; i < columnCount; i++) {
          var currentColIndex = startColIndex + i;
          var currentColLetter = sheet.getRange(1, currentColIndex)
                                      .getA1Notation()
                                      .match(/[A-Z]+/)[0];
          columnLetters.push(currentColLetter);
        }

        var output = columnLetters.join("+")
        // Here is your output
        Logger.log(output)
        // This will show up in the message box
        Browser.msgBox("Output: " + output);
      }