# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/Statistical/Counts.php

TablePress – Tables in WordPress made easy, version 3.4. 97 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Statistical/Counts.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/Statistical/Counts.php
- Modified: 2025-01-08T09:25:54+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Statistical/Counts.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\Statistical;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Exception as CalcException;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Functions;

class Counts extends AggregateBase
{
	/**
	 * COUNT.
	 *
	 * Counts the number of cells that contain numbers within the list of arguments
	 *
	 * Excel Function:
	 *        COUNT(value1[,value2[, ...]])
	 *
	 * @param mixed ...$args Data values
	 */
	public static function COUNT(...$args): int
	{
		$returnValue = 0;

		// Loop through arguments
		$aArgs = Functions::flattenArrayIndexed($args);
		foreach ($aArgs as $k => $arg) {
			$arg = self::testAcceptedBoolean($arg, $k);
			// Is it a numeric value?
			// Strings containing numeric values are only counted if they are string literals (not cell values)
			//    and then only in MS Excel and in Open Office, not in Gnumeric
			if (self::isAcceptedCountable($arg, $k, true)) {
				++$returnValue;
			}
		}

		return $returnValue;
	}

	/**
	 * COUNTA.
	 *
	 * Counts the number of cells that are not empty within the list of arguments
	 *
	 * Excel Function:
	 *        COUNTA(value1[,value2[, ...]])
	 *
	 * @param mixed ...$args Data values
	 */
	public static function COUNTA(...$args): int
	{
		$returnValue = 0;

		// Loop through arguments
		$aArgs = Functions::flattenArrayIndexed($args);
		foreach ($aArgs as $k => $arg) {
			// Nulls are counted if literals, but not if cell values
			if ($arg !== null || (!Functions::isCellValue($k))) {
				++$returnValue;
			}
		}

		return $returnValue;
	}

	/**
	 * COUNTBLANK.
	 *
	 * Counts the number of empty cells within the list of arguments
	 *
	 * Excel Function:
	 *        COUNTBLANK(value1[,value2[, ...]])
	 *
	 * @param mixed $range Data values
	 */
	public static function COUNTBLANK($range): int
	{
		if ($range === null) {
			return 1;
		}
		if (!is_array($range) || array_key_exists(0, $range)) {
			throw new CalcException('Must specify range of cells, not any kind of literal');
		}
		$returnValue = 0;

		// Loop through arguments
		$aArgs = Functions::flattenArray($range);
		foreach ($aArgs as $arg) {
			// Is it a blank cell?
			if (($arg === null) || ((is_string($arg)) && ($arg == ''))) {
				++$returnValue;
			}
		}

		return $returnValue;
	}
}

```