|
COUNTROWS Function
Counts the values in each row of the Table_Range to produce a vertical array of the counts of the rows. Either all information values (COUNTA) or only numbers (COUNT) can be counted.
Dynamically adjusts to the number of rows and columns in Table_Range:
use COUNTROWS when you want non-floating totals for dynamic arrays.
COUNTROWS is a multi-threaded, non-volatile array function.
COUNTROWS Syntax
COUNTROWS (Table_Range [, Exclude_Cols] [, All])
Table_Range
Array, Table, Range or Spill reference whose rows are to be counted.
Exclude_Rows (Optional. Default no rows will be excluded)
Optional. If omitted all rows will be counted.
A list (array or range) identifying the rows that are not to be counted, given as one of:
If Table_Range is not an array: One or more ranges within Table_Range. Multiple disjoint ranges must be enclosed in ( ) – for example (A1:A2,A4) results in rows 1,2 and 4.
Alphabetic labels are used as lookup values in the first column of Table_Range to find the rows. These labels can be supplied in an array or a range.
Relative row numbers are used directly.
These row numbers can be supplied in an array or range.
For example {2,4} gets the second and fourth row of the Table_Range.
Negative numbers work from the bottom upwards so {-1, -2) gets the last two rows of the Table_Range.
Zero acts as an include operator.
{1,0,5} results in rows 1 through 5 inclusive
{1,5} results in row 1 and row 5 only
{5,0} results in row 5 and all rows after row 5
{0,5} results in the first 5 rows
All (Optional. Default TRUE)
Optional. Default True.
True counts cells containing any kind of information but not empty cells (COUNTA).
False only counts numbers (COUNT).
|
