PHPOffice /
PhpSpreadsheet
| @@ 1146-1159 (lines=14) @@ | ||
| 1143 | * @param mixed $arg,... Data values |
|
| 1144 | * @return float |
|
| 1145 | */ |
|
| 1146 | public static function SUM() |
|
| 1147 | { |
|
| 1148 | $returnValue = 0; |
|
| 1149 | ||
| 1150 | // Loop through the arguments |
|
| 1151 | foreach (Functions::flattenArray(func_get_args()) as $arg) { |
|
| 1152 | // Is it a numeric value? |
|
| 1153 | if ((is_numeric($arg)) && (!is_string($arg))) { |
|
| 1154 | $returnValue += $arg; |
|
| 1155 | } |
|
| 1156 | } |
|
| 1157 | ||
| 1158 | return $returnValue; |
|
| 1159 | } |
|
| 1160 | ||
| 1161 | /** |
|
| 1162 | * SUMIF |
|
| @@ 1302-1315 (lines=14) @@ | ||
| 1299 | * @param mixed $arg,... Data values |
|
| 1300 | * @return float |
|
| 1301 | */ |
|
| 1302 | public static function SUMSQ() |
|
| 1303 | { |
|
| 1304 | $returnValue = 0; |
|
| 1305 | ||
| 1306 | // Loop through arguments |
|
| 1307 | foreach (Functions::flattenArray(func_get_args()) as $arg) { |
|
| 1308 | // Is it a numeric value? |
|
| 1309 | if ((is_numeric($arg)) && (!is_string($arg))) { |
|
| 1310 | $returnValue += ($arg * $arg); |
|
| 1311 | } |
|
| 1312 | } |
|
| 1313 | ||
| 1314 | return $returnValue; |
|
| 1315 | } |
|
| 1316 | ||
| 1317 | /** |
|
| 1318 | * SUMX2MY2 |
|
