google-sheets-formula
Sum cells from array knowing a start location and number of cells
I have an array of cells, they run left to right, top to bottom. I'm trying to write a formula that can sum a section of the cells. I need to provide how many cells to skip, then how many to sum after this point. I know how I could do this if they were all in a column, but needing to go left to right and wrap back after 15 cells is new to me.
So for example, skip 61, sum 5, would end up suming A2, A3, A4, A5, A6 and give a total of 94.
Solution
You may try:
=let(skip_, 61, sum_, 5,
sum(chooserows(tocol(A2:O),sequence(sum_,1,skip_+1))))
- Query formula not grouping properly
- Using FILTER with multiple conditions on Google Sheet
- How to union ranges in google spreadsheets
- Formula for filtering list based off of key with multiple criteria in Google Sheets
- Conditional Dropdowns in Google Sheets Based on Multiple Criteria
- Arrayformula Serial Number by Groups
- List rows in array when the cell contain number in the string
- ImportXML XPath issue using Google Sheets on a simple web scraping query
- How to find the Second Space from the right in Google Sheets?
- Find if cell contents exist in array
- OR function not working with arrayformula in Google Sheets
- Is there a way to COUNTIF the number of partial name matches (REGEXMATCH) within a column of cells?
- Using IMPORTXML on Google Sheets to extract image URLs
- How can I make this formula more dynamic by including another criteria (cell F11) in the query?
- Using a reference cell as part of a column in a google sheets query
- Can a formula return corresponding values from one column into another, removing blanks and separating them with commas?
- Using Named Functions with New Google Tables
- Google sheets query not returning words with special characters
- Trying to figure out why my GoogleSheets Date formula is not working
- Why is this conditional formatting rule not working in Google Sheets?
- Google Sheets ARRAYFORMULA with Partial Match and Multiple Criteria Not Returning Expected Results
- Why does my Google Sheets query simplificaiton result in an error?
- How do I set up a formula that matches columns between two sheets, while returning blank values for the first two rows regardless of values
- I do not understand the error message displayed when I try to use QUERY() function in Google Sheets
- In Google Sheets, how do I keep a cell blank based on two other cells' contents?
- Removing protection from a range of cells before automatically deleting with a google script based on date
- How to insert yesterday's date in googlesheet
- How use loop variable in column or row number?
- Google sheets - find the cell containing specific text
- Google sheets formula for showing remaining time per month for descending list of weeks