|
ACOUNTIFS function
ACOUNTIFS counts the cells in the chosen column(s) that match the extended conditions or criteria.
ACOUNTIFS Syntax
ACOUNTIFS (nsortedCols, InputRange, ReturnCol, CriteriaColumn1, Criteria1,
CriteriaColumn2, Criteria2, …, ["#OR#", nsortedCols,] CriteriaColumnx, Criteriax, …)
ACOUNTIFS() should always be used rather than COUNTA(FILTER.IFS()) because COUNTA counts a return of zero as 1 but ACOUNTIFS does not.
See FILTER.IFS for definitions of the parameters for ACOUNTIFS
The InputRange may optionally contain column labels in the first row, in which case at least one of the criteria columns or return column should be identified using a label. If you only use column numbers then the InputRange should NOT include labels
If nSortedCols is NOT equal to zero the InputRange must be sorted on the criteria columns in the DataRange.
If ReturnCol is zero then a row of counts will be returned for each column in InputRange, and ACOUNTIFS should be entered as a multi-cell array formula. This is an efficient method of counting multiple columns for a common set of criteria.
|
