COUNTVISIBLEIFS
Returns the number of non blank cells that satisfies multiple conditions.
| criteria_range1 | The range of cells you want evaluated. |
| criteria1 | The expression that contains the criteria. |
| criteria_range2 | (Optional) The range of cells you want evaluated. |
| criteria2 | (Optional) The expression that contains the criteria. |
Remarks
* This function excludes hidden cells.
* You can use the COUNTIFS function to include hidden cells.
* The equivalent VBA function is COUNTVISIBLEIFS
| | A | | 1 | =JS.COUNTVISIBLEIFS(A2:A8,"London") |
|
