google-sheets

How to select subset of a range in Google Spreadsheet?

I want to extract subset of a range from another range by selecting starting columns and length.

For example, how can I extract B1:C1 from another range A1:D1 by indicating starting columns 2 as in the image attached?

enter image description here

Thanks!

Solution

  • This is easily achievable with the OFFSET function:

    =sum(offset(Range,,StartCol-1,,Width))

    So for your specific example, the expression would be:

    =sum(offset(A1:D1,,2-1,,2))