# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/MathTrig/SumSquares.php

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

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/MathTrig/SumSquares.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/MathTrig/SumSquares.php
- Modified: 2026-09-30T03:50:46+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/MathTrig/SumSquares.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\MathTrig;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Exception;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Functions;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;

class SumSquares
{
	/**
				 * SUMSQ.
				 *
				 * SUMSQ returns the sum of the squares of the arguments
				 *
				 * Excel Function:
				 *        SUMSQ(value1[,value2[, ...]])
				 *
				 * @param mixed ...$args Data values
				 * @return string|int|float
				 */
				public static function sumSquare(...$args)
	{
		try {
			$returnValue = 0;

			// Loop through arguments
			foreach (Functions::flattenArray($args) as $arg) {
				$arg1 = Helpers::validateNumericNullSubstitution($arg, 0);
				$returnValue += ($arg1 * $arg1);
			}
		} catch (Exception $e) {
			return $e->getMessage();
		}

		return $returnValue;
	}

	/**
	 * @param mixed[] $array1
	 * @param mixed[] $array2
	 */
	private static function getCount(array $array1, array $array2): int
	{
		$count = count($array1);
		if ($count !== count($array2)) {
			throw new Exception(ExcelError::NA());
		}

		return $count;
	}

	/**
				 * These functions accept only numeric arguments, not even strings which are numeric.
				 * @param mixed $item
				 */
				private static function numericNotString($item): bool
	{
		return is_numeric($item) && !is_string($item);
	}

	/**
				 * SUMX2MY2.
				 *
				 * @param mixed[] $matrixData1 Matrix #1
				 * @param mixed[] $matrixData2 Matrix #2
				 * @return string|int|float
				 */
				public static function sumXSquaredMinusYSquared(array $matrixData1, array $matrixData2)
	{
		try {
			/** @var array<float|int> */
			$array1 = Functions::flattenArray($matrixData1);
			/** @var array<float|int> */
			$array2 = Functions::flattenArray($matrixData2);
			$count = self::getCount($array1, $array2);

			$result = 0;
			for ($i = 0; $i < $count; ++$i) {
				if (self::numericNotString($array1[$i]) && self::numericNotString($array2[$i])) {
					$result += ($array1[$i] * $array1[$i]) - ($array2[$i] * $array2[$i]);
				}
			}
		} catch (Exception $e) {
			return $e->getMessage();
		}

		return $result;
	}

	/**
				 * SUMX2PY2.
				 *
				 * @param mixed[] $matrixData1 Matrix #1
				 * @param mixed[] $matrixData2 Matrix #2
				 * @return string|int|float
				 */
				public static function sumXSquaredPlusYSquared(array $matrixData1, array $matrixData2)
	{
		try {
			/** @var array<float|int> */
			$array1 = Functions::flattenArray($matrixData1);
			/** @var array<float|int> */
			$array2 = Functions::flattenArray($matrixData2);
			$count = self::getCount($array1, $array2);

			$result = 0;
			for ($i = 0; $i < $count; ++$i) {
				if (self::numericNotString($array1[$i]) && self::numericNotString($array2[$i])) {
					$result += ($array1[$i] * $array1[$i]) + ($array2[$i] * $array2[$i]);
				}
			}
		} catch (Exception $e) {
			return $e->getMessage();
		}

		return $result;
	}

	/**
				 * SUMXMY2.
				 *
				 * @param mixed[] $matrixData1 Matrix #1
				 * @param mixed[] $matrixData2 Matrix #2
				 * @return string|int|float
				 */
				public static function sumXMinusYSquared(array $matrixData1, array $matrixData2)
	{
		try {
			/** @var array<float|int> */
			$array1 = Functions::flattenArray($matrixData1);
			/** @var array<float|int> */
			$array2 = Functions::flattenArray($matrixData2);
			$count = self::getCount($array1, $array2);

			$result = 0;
			for ($i = 0; $i < $count; ++$i) {
				if (self::numericNotString($array1[$i]) && self::numericNotString($array2[$i])) {
					$result += ($array1[$i] - $array2[$i]) * ($array1[$i] - $array2[$i]);
				}
			}
		} catch (Exception $e) {
			return $e->getMessage();
		}

		return $result;
	}
}

```