Returns the number of rows or columns in a section.
This function can be used to compute the address of a section to enable dynamic formulas to calculate a given view section.
This function starts at the bottom or right of a given range and counts each row or column as it processes upward or leftward
until it finds the next section break value.
If the value is not found, this function returns the number of cells from the starting cell range to the start of the SectionValuesRange.
@SectionBreakRowOrColumnCount(<SectionValuesRange>, <StartCell>, <SectionValue>, <RowOrColumn>)
| Argument Name | Description |
|---|---|
| RowOrColumn | A string that specifies whether rows or columns are counted. |
| SectionValue | The cell that contains a value to find within the SectionValuesRange that determines the end of the section. |
| SectionValuesRange | The range containing values to be evaluated to find the SectionValue. |
| StartCell | The cell within the SectionValuesRange in which to start the evaluation. |