IMSUM Function Explained
The IMSUM Function in Microsoft Excel returns the sum of the numbers in a range of cells, based on multiple criteria. It takes up to 127 range/criteria pairs as arguments, and returns the sum of the corresponding cells in the specified ranges that meet the given criteria.
IMSUM Function Syntax
IMSUM(array1, [array2], [array3], ...)
- array1: The first array or range of cells to be added.
- array2: (optional) The second array or range of cells to be added.
- array3: (optional) The third array or range of cells to be added.
- …: (optional) Additional arrays or ranges of cells to be added.