## SUMPRODUCT function. Add and multiply together.(Microsoft Excel)

Japanese version.

How it works=SUMPRODUCT(array1 to 255)NameOmissionSpecifyarray1 ...

## SUMSQ function. Get the sum of squared values.(Microsoft Excel)

Japanese version.

SUMSQ function. Get the sum of squared values.

How it works=SUMSQ(Number1 to 255)NameOmiss ...

## SUBTOTAL function. Aggregate only the values displayed.(Microsoft Excel)

Japanese version.

Aggregate only the values displayed.

Aggregate functions, such as the SUM function, inc ...

## PRODUCT function. Perform multiplication.(Microsoft Excel)

Japanese version.

The PRODUCT function is a companion to the SUM function.

While the SUM function adds, t ...

## ABS function. Get absolute value. SIGN function. Get Signs.(Microsoft Excel)

Japanese version.

The ABS function can be used to get a number without a positive or negative sign.

The S ...

## QUOTIENT function. Get the integer part of the result of division.(Microsoft Excel)

Japanese version.

Get the integer part of the result of division.

How it works=QUOTIENT(Numerator,Denominato ...

## POWER function. Performs a power of power calculation.(Microsoft Excel)

Japanese version.

Performs a power of power calculation.

How it works=POWER(Number,Power)NameOmissionSpecify ...

## RAND function. Randomly obtains a small number greater than or equal to 0 and less than 1.(Microsoft Excel)

Japanese version.

Randomly obtains a small number greater than or equal to 0 and less than 1.

However, fo ...

## LARGE and SMALL functions. Get the number corresponding to the rank.(Microsoft Excel)

Japanese version.

Get the number corresponding to the rank.

It works in reverse of the RANK function. ...

## RANK function. Get the rank in the range.(Microsoft Excel)

Japanese version.

Get the rank in the range.

The RANK function has two functions that differ in their tre ...