Sum

SUMPRODUCT with IF

In this example, the goal is to calculate a conditional sum with the SUMPRODUCT function to match the criteria shown in G5:G7. One way to do this is to use the IF function directly inside of SUMPRODUCT. Another more common alternative is to use Boolean logic to apply criteria. Both approaches...Read more

Math

MDETERM Function

The MDETERM function returns the matrix determinant of a given array, which must be a square matrix containing numbers only, and no empty values. In mathematics, the matrix determinant is a scalar value (single value) that is a function of the entries in a square matrix. The determinant...Read more

Math

MINVERSE Function

The MINVERSE function returns the inverse matrix of a given array. The product of a matrix and its inverse is the identity matrix, a n × n square matrix with ones on the main diagonal and zeros in every other position. 

The MINVERSE function takes just one argument,...Read more

Math

MUNIT Function

The MUNIT function returns a unit matrix for a given dimension, n, with a size of n x n. The unit matrix is also called the identity matrix. The MUNIT function takes just one argument, dimension, which should be a positive...Read more

Pages