COUNT

Counts a number of cells in a range that contains numbers ignoring empty cells or those contaning text.

Syntax

expression.COUNT(args);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
args	Required	string | number | boolean | (string | number | boolean)[] | ApiRange | ApiName		Up to 255 items, or ranges to count numbers. The first argument is required, subsequent arguments are optional. Arguments can be numbers, logical values and text representations of numbers, ranges, names, or arrays.

Returns

number

Example

Count cells containing only numbers in a spreadsheet.

// What is the total of numeric entries in a range in a spreadsheet?

// Determine which cells have actual values instead of blanks in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let numbersArr = [45, 6, 8];
let stringsArr = ["Apples", "ranges", "Bananas"]

// Place the numbers in cells
for (let i = 0; i < numbersArr.length; i++) {
    worksheet.GetRange("A" + (i + 1)).SetValue(numbersArr[i]);
}

// Place the strings in cells
for (let n = 0; n < stringsArr.length; n++) {
    worksheet.GetRange("B" + (n + 1)).SetValue(stringsArr[n]);
}

let func = Api.WorksheetFunction;
let ans = func.COUNT(worksheet.GetRange("A1:C3"));
worksheet.GetRange("D3").SetValue(ans);